I want to know if it is possible to create backups on differnet schedules of the same database? And if not, if there some solution that can fit what I am trying to do? I want to backup more aggressively to a locally attached disk, and less aggressively to a network device. Specifically a vir...more >>

Hello,Why an sp autoblock ???? If exec my sp and view the connections with sp_who i watch te id of my connection in the column blk of the result. Why succedes this ?? Thanks in advance. ...more >>

Pardon my long windedness, but I want to provide a full explanation. I have very limited (next to none) knowledge of SQL Server or NT / 2000 Server. We had a membership database stored on an SQL Server 6.5 on an NT system. We accessed it via a custom written Visual Basic program called Mem...more >>

How can I lock a table for updates and not for selects? Thanks, Avi ...more >>

Guys Bizarre...using SQL Server Management Studio Express...v 9.0.2047 logged in as 'sa' I right click a stored proc...i see options for... - New - Modify - Execute - Script - View dependencies - Rename - Delete - Refresh ....my 'Properties' option is GONE...DISAPPEARED...MISSING.....more >>

I'm writing a small app to bulk load some data and receiving strange results. Some of the data contains non-standard alphabetic characters, like the name Jose (with an accent over the e). It is being loaded into the table as JosT. The column is a VARCHAR(50), and it seems to work with reg...more >>

Working on a vendor database upgrade. They want the clustered index to be rebuilt. I have huge table with more than 10 million records.....have a clustered index and 10 non-clustered indexes... what are my options, As an example lets take Orders table and CIX_Orders is the clustered index...more >>

I have table with several million rows, which I would like to move to partition schema. I've found this option is present in ALTER TABLE command. However, this command alter table TaleName move to ps_Schema ( PartitionColumnName) resulted in error: Msg 102, Level 15, State 1, Line ...more >>

I have the following RPC which is followed by 2 fetches (of 100 rows) and then a close. Query returns 150 rows. When I run it through the query analyzer, it runs fast. Each time through the VB app, the first set of 100 takes 20 seconds with over 10 M reads. The second set takes 7 seconds wi...more >>

Hi, I'm interested in querying my domain's Active Directory database from SQL Server 2000. In particular, I would like to be able to take a network user name and determine its membership in network groups so I can list all the network logins that user has to a SQL server instance. I would...more >>

We have SQL Server 2000 with about a dozen databases. I believe some of these databases are not being used. Is there a way I can tell which is being used and which ones are not. Thank you, Jeff...more >>

HI, I know what I should do is jus change the password, but there are over 100 jobs and DTS package connections that run with sa auth, and that will take a long time, unless someone knows how that can be automated to change all sa users to something else, sorry that's another question. The i...more >>

Hello all, Will data/log files be defragmented by Windows Defrag even if they are still attached? -- Thanks for any help anyone can provide, Conan Kelly ...more >>

URGENT>> I am having a problem. Our production server crashed this AM. We unfortunately did not have a backup on one of our databases that is considered critical for recovery. So, a database restore is not an option at this point. However we do have the MDF / LDF files. Is there an undocume...more >>

I've read BOL on establishing a DB Maintenance Plan using the Wizard but it really fails to make any real-world recommendations (that I can find) about timing and options. I want to create a plan for an web application production database of about 1.3gb in size with no scheduled downtime. Are ...more >>

I am having trouble executing a stored procedure on a remote server. On my local server, I have a linked server setup as follows: Server1.abcd.myserver.com\SQLServer2005,1563 This works fine on my local server: Select * From [Server1.abcd.myserver.com\SQLServer2005,1563].DatabaseN...more >>

I have a table that has a column 'book_id' which is the primary key. There is also a column 'createuser_id' with the index 'tt_book_createuser_id_x1' on it. When I run DBCC SHOW_STATISTICS for the 'tt_book_createuser_id_x1' index I see the following in the all density section of the output: A...more >>

I have SQL Server 2005 Workgroup Edition running on Windows XP. When creating ODDC connections from other computers, they can connect to this server via TCP, however, not via the server name. On the SQL Server 2005 server both TCP and NamePipes are enabled. Any suggestions ASAP would help...more >>

Hello I need to export my table fixed filed size by making numbers 15 characters right alignment and strings 20 characters left alignment. ...more >>

Hi, I have a table TABLE1 with columns ID, NAME, DATE1 I need to write a trigger that will update DATE column to current date time, after every sql update operation on record. So my trigger looks as follows: declare @row_id bigint set @row_id=(select id from inserted) update TABLE1 s...more >>

Hi, does any one has performance comparison between storing data in XML format and relational tables. For e.g performance with respect to search etc. Perf numbers would be great if any one has metrics in SQL 2005. regards Muralidhar ...more >>

Hi all, I am using third party application that can only use sql authentication. If we use windows authentication it will accept any password once the username is correct. If we are force to use sql authentication, is there a script or a way that we can force the sql users to change password ...more >>

Hi, I have a table with 8 fields: a primary key - nvarchar(10) 3 datetime fields a bit field and 2 int fields related to other tables. The table currently contains 2,400,000 rows and the requirement is that it should work with 50,000,000 rows. I have used Query analyzer to run very simpl...more >>

Is there any function or something like that that returs the amount of MS SQL Server 2000 memory usage? Thanks. ...more >>

Hi, All I'm use SQL Server 2005 and want to know is any way can retrieve windows user account? I want to retrieve windows user account and insert into the table. I don't want to use any program lanaguage just want to know SQL 2005 has any kind of function or store procedure can support thi...more >>

We've just setup some new Microsoft SQL 2005 servers running windows 2003 R2 x64 with 16GB of RAM. Since we are running a 64 bit version of windows and a 64 bit version of SQL, is it any longer neccesary to add the /3GB /PAE option in the boot.ini and enable AWE in SQL? Thanks! Brad ...more >>

Hi, I have an app that connects to a remote SQL database using 1433. It connecting using a locked down user then runs a stored procedure passing it XML. Roger Walter pointed me in the direction of SOAP, SQLXML web service. I installed: SoapToolkit 2.0 SoapToolkit 3.0 SQLXML 3.0 sp2...more >>