Hi evrybody,
I MBA Systems (2005 passout) and doing OCA & OCP.
but currently doing job as HR (1.5 yrs exp).
I want to know How tough it will be for me to get job in Software?
Is it so easy guys?
In 2000 there was a server level setting you could change in EM, to allow direct modifications to systems catalogs.
in 2005 I would like to update some sids in sysusers tables, do I also need to find and set this option first
We're planning to migrate our db to new and more disk drives, fasterRAID levels and more dedicated disk usage(e.g. placing the translog ondedicated disks). The db server runs on Win2003.Right now we're thinking about what file system to use on the newdrives. We opt for performance, but expect reliability as well.(Goeswithout saying, IMHO ;-))
Quote:
I want to change the (dateformat) columns in (syslanguages) tables from dmy to mdy in SQL Server 2005,
but the update query did not success, and error message (Ad hoc updates to system catalogs are not allowed) .
Although I used
sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
before executing the update statement.
Can any body help me.
hi all,
i have a requirement that web service running in one system and sql server 2005 database running in another systems which is not working currently.
suppose i create end point in the system where sql server 2005 database is there,then its working fine.
Actually for creating end point we should have windows server 2003 or SP2.Configuration part i dont have any hindrance.
Can any one tell how to run webservice in one system with sql server 2005 in another system.
Thanks
venkat
hi guys,
i am having a truble in accesing the server 2005 express edition from my client systems in server 2003 domain network. i get server not accessible. whereas my domain is working perfectly. i really tried alot and i have enable tcpip and named pipes and i am still getting errors while accessing. i have also created user reights for the domain users to access sql server. still i couldn't able to access it.
please guide me to over come this issue. I'm dying.My project is similar to SAP concept project and i am doing it in a production industry.so each department as to access the data from the server to update their daily production and activity.
thnks in advance.
Viswa
I have created a VB 6.0 application that reads data from old db files into the SQL Server 2000 database using DTS stored structure files.
The application works fine with Windows NT but I keep getting an error in Windows 2000 environment.
"-2147220441(80040427) Execution Canceled By User"
Any ideas why?
I have a problem where Backup Exec crashed during a backup of a SQL database and now SQL show 3 extent lock that are now redundant. These cannot be removed from Enterprise manager Is it therefore possible to remove them directly from the master database ??
Thanks
I need to syncronize two separate databases. One is SQL Server the other is MySql. I don't have a lot of experience with MSSQL and need a little advice on how best (in terms of speed especially) to gather records that have been added since the last sync and any that have been modified. The table in question has datetime fields for both, the time each record was created (CreatedTime) and the time that the record was last modified (ModifiedTime). Sync will happen daily.
I have worked out a few ways I might do this with DATEADD or DATEDIFF, but my question is, what is the most effecient way? Currently I'm just looking for a way to get inserted and updated records from SQL Server to MySQL. I may have to do a two way sync of some sort later.
I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks
informatics
I was wondering if anyone could suggest a web-based help desk systemthat uses MS SQL server that also has a knowledge base and also allowssupport employees to log how much time they have spent on eachparticular ticket. I'm after an 'affordable' system that would be usedby about 35 people.Otherwise, if you can think of a better place to ask around, let meknow!Regards,Belinda
View 1 Replies View RelatedI have a client that would like to archive all of the documents .word, .xls, .pdf, .jpg, email coorespondance, etc. into some sort of database so in the near future when the project starts up again all of the information is in a clear consise format. I was hoping that this forum could provide some guidance in selecting a software package and a discussion on how to proceed.
I have 6 gigs of documents in a folder on our server.
I was planning on delivering the organized data on a external hard drive after putting the data into some sort of database.
I would like to include metadata about each particular document.
like
who created the document,
Key words about the document's purpose,
time frame the document is revelant for,
and so on.
I would like to use a database structure and possibly hot link the document to the DB.
I would like to use xml (if possible) for the metadata.
any help is greatly appreciated on this
I can be reached at
khively at maximusa dot com
for any additional questions
Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.
Thanks.
Hi everyone,
Im having a hard time deciding what approach should I take. The scenario is this: I have developed various systems (inventory, HR, accounting, etc.). All this systems are (and should be) tightly integrated with one another. At present, for all these systems, i've used a single DB prefixing the tables with the systems name (eg. Inventory.Items).
My question is: did I did the right (and practical) thing? Or should I create a DB for each system to organize them? The problem with multiple DBs is some system uses the other system's table(s). Example, if i created a separate DB for accounting, and a separated DB for inventory, and another for HR, how am I going to relate inventory and HR's accounts to the accounting DB's table? I want a single instance for each table; I don't want to create another account table for inventory or HR so I can enforce integrity. And if different DBs, is there a performance impact on this?
Or is there another way? My concern is performance and manageability. Please help. Thanks!
I currently run SQL Server 2005 64-bit Developer Edition (Service Pack 2 - it will be SP 3 as soon as I can get hold of it). I am running this on a stand-alone box with Windows Server 2003 as the OS.
Soon, I will be buying another computer for a colleague who will be running SQL Server as specified above. However, I am not happy with Windows Server and am wondering about changing to either XP 64-bit or Vista 64-bit. The machine will not be networked.
I would welcome advice on this since, in some ways, I would be happy enough to use XP or Vista, and think that 64-bit development is more likely on Vista than on other Windows OS's. However, I am not convinced that SQL Server 2005 works with Vista and, like everyone else, have heard plenty of complaints about Vista.
All advice gratefully received.
Thanks.
Chris
I'm working on an income deferral problem and we are using IRR to end up calculating periodic income.
As an example, I have the following inputs:
Number of periods = 9
Initial Loan = 21.46
Instalment amount =15.30
Future value=0
Guess=0.1 (10%)
Using a compiled function from Visual Studio in SQL Server 2008 we get a result of 70.71656373
Using a Microsoft Access function we get NaN
Using Microsoft Excel we get NaN
Using a web calculator we get 70 (ish, the calculator rounds the numbers)
I know that the numbers are odd, some of our data is dirty so we do expect that. I was expecting the SQL process to kick out an error (therefore converting the result into 0), but it doesn't.
Hey guys want a suggestion from you I am a Masters Student here in USA This forum helped me a lot when I was doing internship.My university is offering tution wavier for these to jobs "1)backup systems support
2)Database admin" .I know MySql also took course for basic database .
The question is if any of you please tell me what all I have to do in these job if ...if ... :) I get this job .Thanks based on your answer only I will apply for this job its 20 hrs a week commitment with college
assignment .
Thanks
Sam!
I was going over this article , and was intrigued by this statement "If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express."
What are simultaneous connections? Is this related to Max worker threads defined as 255 on other editions? How does underlying OS impose how many connections can be done to SQL server. And finally how many simultaneous connections can be done in Windows Server 2003?
I am using SQL 2005 with reporting services, I have very basic reports, most users can print fine with the print icon in the toolbar, some users get the Blue screen and have to reboot. They have the rsclientprint.dll loaded in the browser, we have deleted it and reloaded, what do I do ?
View 1 Replies View Related
Hello,
I am in the process of learning SSIS to step into a business intelligence role in my company, which is a Microsoft CRM/GP VAR. I plan to use SSIS for building data warehouses. However, I'm aware that my company also uses a tool called Scribe to integrate data from non-CRM systems into Microsoft CRM. Can anyone explain to me the difference between SSIS and Scribe? Can SSIS reasonably accomplish what my company now uses Scribe to do? Mostly, Scribe seems to be used for scheduled one- or two-way scheduled data pushes.
Thanks,
Andy
We are currently utilizing a risk management software that is using a SSMS back end. However the database is extremely normalized and hard to find data. I am looking for one particular item (column) to bounce against another report I created, to find the delta's.
I found an XML string that looks to have data captured in it, almost like VB marked up in XML. This XML has the column name (source and the desitination column). However when I go into the other tables I am unable to find either column?
Could it be that the application is referencing the XML strings in the column to present the data through the application? Is this some sort of way to prevent people from back dooring their data? Maybe I just missed the table with the column name.
Hi all,
I am a Windows Sysadmin (Active Directory, infrastructure, etc) with light knowledge of SQL 2005. I can set up the database cluster on a shared storage device, I know how to get the heartbeat, do simple backups, etc.
My question pertains to disaster recovery. Right now, we use a product called DoubleTake to copy our database over and 'assume' the identity of the failed SQL server. There are two problems with this -- cost of the license of DoubleTake, and additionally, is it the best method?
I have read before, that you don't need to be a DBA to set up a DR scenario for SQL. My goal really is to have two databases -- one in our production location, and one in a DR location that is pretty much cold (for licensing issues).
If our production database should go down, then it would fail over to the DR site.
What is involved in doing this, what type of steps are required, do you NEED a DBA to manage this, or can a sysadmin (such as myself) take care of it? Also, is it worth having DoubleTake to do this job, and does it do a better or worse job, are there limitations, etc.
Thank you for any replies you can give, and please keep in mind that I'm far from a DBA .
I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. Here is where I am stuck. Some systems may have multiple cases opened within the same span of another cases however we would consider this one failure:
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase22013-07-12 16:27:50.0002013-07-12 16:29:12.000
System ACase32013-07-12 17:30:32.0002013-07-12 17:40:11.000
System ACase42013-07-12 19:00:24.0002013-07-12 19:04:14.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
Lets say System A generated those 5 cases however Case 2,3 and 4 all happened within the same period as Case 1 so those 4 cases should count as one failure so my end result should be
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
And that system should show me 2 failures. I was thinking of using a temp table but not sure if that is possible as I am stumped on how to compare the dates to be able to validate if they fall within the range of an older case and whether or not to include them into the new Temp Table.
We are migrating data from old DB2 systems to sql server 2012, the DATE FORMAT in those systems is in decimal format with 7 digits. CYYMMDD format.
I need to convert this into DD/MM/YYYY format.
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
First of all I am planning to install sql 2005 standard and sql standard sp2
on vista ultimate professional using vs 2008 pro
I have some questions about installing sql 2005 what is the best way to install sql 2005 on
vista My article I got this from ms 403393 (upgrading sql standard 2005 to sql standard 2005sp2)
1 sql standard .(shortcut right click from cd/dvd not possible) I have heard command prompt start menu, click cmd
type run D: cd/dvd exe
From a wizard (sql sp2)
2. sql standard sp2
a. upgrade using a wizard
b. open a command prompt (not sure if right click is best option)
install dvd media example dqlserver2005sp2-kb921896-exe SKUUPGRADE=1(is run as administrator option on media)
do I type run or what do I type ?
c. go to system configuration page(where is this) you should see a single warnining you need to install
sp2, the edition should say success if it does not please reapply
d. on the registration page please enter your registeration number
e. on the comments to install please enter database services, reporting services
workstation components, books online and development tools( I wish to install
all components)
f. on the instance page click default instance(default install)
g. finish rest of wizard
h. apply sql sp2
I also have of seperate question of upgrading sql from vista using a Configuring local admin account
account (configuring administration from a wizard-will this notify
me by default) I do not want my administrative priviledges elevated.
I will be using default configurations for my installations.........
I often wish there would a nice picture examples of doing this
Please help
I have a problem regarding forwarding 'n number of parameters' from Visual Studio 2005 using VB to SQL-Server 2005 stored procedure.I have to save N number of rows in my stored procedure as a transaction. If all rows are not saved successfully, I have to roll-back else update some other table also after that. I am unable to handle - How to send variable number of parameters from Visual Stduio to Sql - Server ? My requirement is to use the SQL-Stored Procedure to store all the rows in the base table and related tables and then update one another table based on the updations done. Please Help .....
View 1 Replies View RelatedI am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
We have a large number of clients attempting to replicate two publications on 2005 Express databases (2 publications subscribed to the one subscriber database) with our 2005 Server (9.00.3042.00 SP2 Standard Edition) and experiencing two significant problems:
1) Users experience the following message:
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Subscriber for changes not yet sent to the Publisher. You must reinitialize the subscription (without upload).
This problem should not apparently occur with SQL Server 2005 (or 2005 Express) instances with SP2 applied. All clients experiencing this problem have SP2 installed as does our Server and the retention period is 30 days. The subscribers have been replicating well under that.
2) Replications never succeed after appearing to replicate/loop around for hours
This issue is the most critical as we have clients who have been installed and re-installed with new instances of SQL Server 2005 Express, new empty databases (on subscriber before snapshot extraction), and using fresh snapshots (less than an few hours old) which cannot successfully replicate.
Interestingly there is at least 1 instance where several computers are subscribed and successfully replicating the same database as another where replication refuses to succeed.
To test we have taken a republished database from another 2005 Server which is working fine and restored it to the same server as the one holding the database with which we are experiencing problems and subscribed to it. This test worked fine and replication of both publications went through fast and repeatedly without showing any signs of problem.
This indicates that the problem is perhaps data related as it appears localised to that database.
Below are two screenshots which may assist.
Screenshot 1 Shows that on the server side the replication attempts look like they are succeeding despite the fact that the subscriber end does not indicate success. Also the history indicates the the subscription has spent all it's time initialising and not merging any changes.
Screenshot 2 Shows a rogue process which has appears on many of the problem child subscribers. It shows a process running with no end time even though the job indicates failure in the message and even though other replication attempts appear to have succeeded after it. This process stays in the history showing that it is running even when I can find no corresponding process for it.
Can anyone suggest a further course of action/further testing/further information required which may assist?
This is extremely urgent and any assistance would be greatly appreciated!
Thanks in advance!
Scott
Hi,
Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device.
Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use ?
thnx,
pdns.
Hi,
I have created a database using VB Express 2005 express edition and I have created number of tables and SP's etc.
I am trying to use the database diagram tool but I get an error stating that the database doesn't have a valid dbo. I say yes to the prompt about making myself a valid dbo but I then get a message stating that I do not have permissions to imprersonate the dbo.
How do I overocome this issue?
Thanks
Bill
Hello everybody!
I hope that someone could help me.
I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...
I configure the connection to use the IUSR.
The source code that i use:
repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll";
repl.Publisher = @"laptop";
repl.PublisherDatabase = @"database";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"Pubdatabase";
repl.Subscriber = @"SQLMobile";
repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'";
The error that returns is:
"Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect"
Does anybody knows what i can do?
HELP I NEED SOMEBODY TO HELP!
Thanks!
Is it possible to parm in a value to a SSIS
in my SSIS i have a variable;
Name : FileName
Scope : PackageName
Type : String
Value : ""
I have tried adding the following code in my vb.net project ;
pkg.Variables("filename").Value = "C: emp estfile.001"
pkg.execute()
but come up with the following error
A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll
Public member 'Variables' on type 'IDTSPackage90' not found.
can anyone help ?