Hi everybody! I have the following problem: I have many tables in my database and for some columns it happens that when I try to update them, I get the error message, that the update doesn't work properly, because of "Key column information insufficient or incorrect". This happens only for a f...more >>

I understand that the 64 environment allows more addressable memory. Are there any additional performance benefits other than possibly those gained by increased memory addressability? Assuming the same database running on a 32 bit environment and a 64 bit environment and applications hitting b...more >>

I am going to do a sizing of memory for a server SQL Server. I am finding the calculations of memory for each user connected to the SQL Server for carry out this sizing. I stayed grateful by any help. Thanks! Jonildo ...more >>

Hi guys, i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo" function in a module 5 but when i run a sys.fn_indexinfo how indicated a error showed Seems that not exist ... it's possible ? It was replaced ? If so how i can view a index defrag status ? Thanks in advanc...more >>

I have 300 records in one table. I want to select that in 3 times, each time 100 rows. Anyone have some idea how to do that?? So, I would have 3 queries and each query would get 100 records. If anyone can help.... Thanks!! ...more >>

I am trying to export and XML Explicit query using bcp and occasionally an element descriptor is trunctated on larger files. Any suggestions on how to avoid this problem. Is it possible to force a linefeed after each element in the sql output? TIA Rob ...more >>

Hi, I have a real "noob" question, and I'd appreciate it if someone could help me out. Below is the general specs of the server I am running. Product: Microsoft SQL Server Standard Edition Operating System: Microsoft Windows NT 5.2 (3790) Platform: NT INTEL X86 Version: 9.00.2047.00 Memo...more >>

When I look at the properties of the SQL Server and go to the Security Tab, the startup service account area is greyed out. Why can I not see if it's using a local system account or a domain account? (Windows 2003 sp1 server running SQL2000 sp4.) Thanks ...more >>

Will creating an index while a database is in use block user access? Thanks. ...more >>

What if we want to take complete backup of production database except values in a particular column of a table. Suppose if we don't want to reveal social Security number of employees . Can we take a backup to send the offshore team with no data in SSN column of employee table. ...more >>

I am collecting objectids in a SQL Server 2000 Profiler trace. I am capturing the events: Stpred Procedures: RPC Completed and SP Completed and TSQL: SQL StmtCompleted. When I try to identify the objects being called either with object_name(id) or marching on sysobjects I get many objects ...more >>

I was recently given a db script that was generated from an Oracle db. I need to put the db in my SQL server using this script. Is there a tool that will convert the script for me, or do I have to do it all by hand? It will take me days to do it by hand. Connecting to the Oracle db is no...more >>

I register the server using SQL Server Enterprise Manager. Next day, all my settings are gone. So I need to register server everyday. ...more >>

What are the differences between Remote Server and Linked Server anyone have a good reference page ? ...more >>

Hi, I have a database user with read-only permissions in the database. The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do this, but without granting permission to *change* the sp's in any way. Is ther...more >>

I need a SQL query that could give me a processor count and mhz info from query analyzer. Please help Thanks, John...more >>

Howdy Everyone, In SQL 2000, I used SQL Enterprise Mgr --> Task --> Transfer Logins Task --> Source Tab (select sourcce sql server name--> Destination Tab (select destinate sql server name) --> Logins (select database name). What about in SQL 2005? I am new at SQL 2005 but love to learn n...more >>

Hi All, I need to take a backup of a database without taking backup of few tables. So if i have a database Name production with a number of tables including salary table. All I want is to take the backup of complete database without taking backup of Salary table. Isthee any way to do so? ...more >>

I am importing a table in my db from a txt file having data fields separated by ' ; ' After the import, I want to make one of the field as numeric which is imported as varchar. The problem that I face converting is the data that I get can be negetive. During import negetive value comes as varch...more >>

how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt seem to work as it did in mssql97 & 2000 thanks, Raul Rego NJPIES ...more >>

What are the SQL Server commands that will shrink or release database transaction log used disk space afer the database backup has completed? Thank You, ...more >>

Hi, Can I install SQL 2005 side-by-side with SQL 2000? Any good articles on this? Thanks ...more >>

Hello everybody, I am trying to run an SQL Server 2005 job which is made up of one SSIS package. The SSIS package run successfully when I start it manually, but as soon as I include it in an SQL Server Agent I get the error message mentioned in the subject. Any ideas? Thank you in ad...more >>

Hi I need to create a stored procedure that can do the following but now sure if it can be done with sql2000. 1. read in existing data from a table. 2. create the current Julian date. 3. make a comparison and add a sequence number onto this number if it is a specific Julian date. I think...more >>

Hello, I am looking to T-SQL extract records from a table and have each record stored in individual .eml files. A query based DTS doesn't let me specify what extension my files will have AND I'm unsure how to have each record written to a separate file? Any ideas on how I can pull this off?...more >>

Someone help me please. I'm confused. I've got a brand new Maintenance Plan which reorganizes indexes, clears out the MP history and updates DB stats. It refused to save with a schedule of once a week on Sunday at 1:00 a.m., but did save without a schedule (on demand). I have reopened t...more >>

Hi All I am trying to create a linked server to MYSQL and it is not listed in the Linked Server providers in SQL Server 2005. How do I go about adding a provider that is not in the existing provider list? Any ideas on how to either add the provider or create the linked server would be a...more >>

Hi, I wanted to know why the nested transaction is used. If I am not wrong, what I understand by the below SQL is that the "commit tran outer1" should be run to commit the entire transaction and to release the locks hold by transaction. and if the rollback happens anywhere, the entire transact...more >>

Hi, I am trying to restore transaction log backup for one of my database using following statement. RESTORE LOG mydb FROM DISK = 'c:\mydb.trn' WITH RECOVERY GO but it is giving error like :- Server: Msg 4306, Level 16, State 1, Line 1 The preceding restore operation did not sp...more >>

Hi I want to get SQL Server version. I know this way: Select @@version But this gives me a very long string, i.e. Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: ...more >>

Whenever the update statment is executed the patient table will be locked even for the querying. Is there a way where in the select locks the table so that the other transaction will not even able to select. If change the isolation level to repeatable read or higher it will not allow update a...more >>

Hello there. Is anyone aware of the following issue when updating a column in SQL Server 2000? I perform an UPDATE on a new column whose value is currently null. Example: UPDATE table SET column = 0 Once this is done, the values from another column (not in the quesry) are cleared. W...more >>

Hello, Current setup: 3 instances of SQL server 2005 on a 2 CPU box. How do I use IO/affinity to ensure that all SQL Server related I/O goes to the first CPU? I'm aware that sp_configure is the command to be used. But how do I exactly specify that the first CPU is to be exclusively used fo...more >>

Hello, I have to test a .NET 2.0 Application which runs locally on my PC. All files are e.g. in the Folder DESKTOP\APPLICATION including the file LocalDB.mdf. When I started the Application for the first time, it runs perfectly. Then I moved the folder to C:\APPLICATION and now it will not ru...more >>

Everytime I enable AWE on my SQL server the SQLSERVR process loses the ability to increase in memory. I am running Windows 2003 Ent. & SQL 2000 Ent. SP4. My Server has 4 processors and 8 GB of RAM. I am trying to give 5 - 6GB of RAM to improve its performance. If AWE is off then the SQL s...more >>

Hi, We have a requirement to read the .trc files generated by SQL server in real-time or atleast near real-time. We do not want to interfere with existing SQL server setup by running functions like fn_trace_get_table. The requirement is to get the events logged in .trc files by directly readi...more >>

Hi I have a table with a set of possible duplicate values. The table contains information on users with the folllowing fields: Name Telephone Number Email Address DateOfBirth Duplicate Now i want to update this table (through the Duplicate flag) to set records which have the followi...more >>

Hello All, I worked as a DBA when SQLServer 7 was released and was instrumental in migrating our SQLServer 6.5 to SQLServer 7. At that time Microsoft had released migrate/upgrade wizard that, given the source db, would create the source db on SQLServer 7 and migrate all the data. I'm ...more >>