Hello: What is the difference between rebuilding index and dropping the index and recreating it? Any pros/cons in each? Thanks, Q...more >>

Hello: We have a table that has 3 indexes: one clustered and two non-clustered indexes. I am thinking to rebuild them, as some indexes may be corrupted. In general, is there any pros and cons in rebuilding indexes? Thanks, Q...more >>

We have created a database in SQL Server 2000, and now want to distribute this database to msde. Howe do we do this. First how do we get the database structure on msde and how do we get the users into msde. Is there any management tools for msde, like SQL Server/...more >>

Hello, I am new here so I am sorry if this question is a little bit novice:) Here is my problem, I am DBA with some 2 years expirience. I have an database wiht FULL recovery model: Data file is for now about 800 MB, adn Log file on separae disk is 1050 MB. So..I have my back up procedure ever...more >>

I want to write a statement to query object permisions in a database. How do I do this. Thanks in advance for any help. ...more >>

Hi, I am hoping that someone can help me with a question. I could be being a complete donkey, but my SQL experience is limited. I am working on a damage recovery guide for my business. We have a server running SQL 2000 Enterprise edition with a 30Gb database. I am trying to find out if ...more >>

Hi, I had a problem with one database. The hard disk of the server is damaged but I could get the files mdf and ldf for the database. I don't have a backup file, but I wonder if I can recover the database information with these two files. Thanks...more >>

What is " my sql server"and why do I need it ? -- like to be informed...more >>

This is very basic but so am I. I need to switch my database to a new hosting company. I have never used sql but both my old and new hosts have liscenses and will support existing databases but wont help me transfer. I have downloaded the trial version and just need to make a back-up of the...more >>

i am asp.net developer with c#.recently i confronted with a p roblem that is i want to execute a server control in side a script function ,ie when we are submitting a page the 'onclick' function will call say 'saveform()' function,Inside the saveform() function how i can execute a code similar...more >>

Trying to replicate Northwind on the same server in SQL Server 2000. Keep getting the message: [SQL Server Agent on "XXXXXXXXXXXX" currently uses the system account, which causes replication between servers to fail.] If I go ahead and enter the default when asked for a new system I get this...more >>

Hi all I am working on a mp3-Managment-tool with a SQL-Database. I got into troubles with a few files that have '[' and ']' in their filepathes or in any mp3-TagInfo. When I do some queries on these files e.g Select * from Musikdatei Where m_Dateipfad LIKE 'C:\Xavier-Naidoo - Ich kenne ...more >>

I want to do something like: SELECT * FROM table WHERE * <> 'NULL' Obviously I could do this on a field by field basis, but is there an easier way? -- J.B.Moreno...more >>

I am trying to link to another SQL Server from Linked servers. The problem is that I am seeing a lot of tables starting dtPropertiesm MSreplication_options ... sysxlogins But none of "my" tables. I am sure that users have full rights in both servers and I even tried us...more >>

I am an asp.net developer using c# and working in Winxp and wanted to use SQLserver2000 as back end ,while i am trying to install it shows amessage that only client components is possible to install.plz help me what ishould do to install the complete package...more >>

I installed MSDE 2000 with parameters SAPWD='ahoj' SECURITYMODE=SQL Installation was OK, I enabled all networks protocols in SVRNETCN.exe and restared server. osql.exe -L found 1 server: (local); But if I try to start osql.exe -U sa and write a password, osql says 'Login failed for user sa'...more >>

i installed msSQL2000 Enterprise evaluation and it is about to expire (120 days). purchased msSQL2000 developers edition and need to know if i can somehow just overwrite or whatever or if i have to uninstall dev. scary thought. i tried by loading dev sever cd and it did not find my present...more >>

Hi, I hope someone can help with this, I have just downloaded and installed a copy of MSDE 2000, on the pre-text that it would be similar to a standard edition on SQL Server, but this does not seem to be the case, after the install all I seem to have ended up is with a new service in my com...more >>

Hi, I'm having a big problem trying to create a query. I have two tables as described below: Table 1 Table 2 code code col1 col4 col2 col5 col3 col6 col1 has the same kind of data as col4, col2 has the same kind of ...more >>