Search results for query: *

Hi All, I am getting this message in the server event log once a day , THE MSSQLSERVER SERVICE TERMINATED UNEXPECTEDLY. IT HAS DONE THIS 1 TIME(S). THE FOLLOWING CORRECTIVE ACTION WILL BE TAKEN IN 0 MILLISECONDS: NO ACTION. Since this a testing environment this is not a big issue, but I...

How is it possible to find all the Instance (7.0 & 2000) of SQL Server on a Machine. I want to build a build a wizard, that will take the machine name alone and get the list of SQL Server Instances on it. Helpful tips will be highly appreciated. Thanks in Advance

Hi all Look at the example given and pls provide a suggestion on how to improve the performance Table : Test , Rows : 2243434 Columns : 5 Column Details : Col1 Numeric (primary key) Col2 Numeric (references other table FKEY) Col3 Varchar(10)...

Is there a way to get the Current Identity Value of a table from any System Table ?i.e an SQL Query to get the Current Identity Value. I Don;t want to use the Functions given in SQL. If it is not stored in the System Table how is this maintained. Regards Thyagu

Hi All I am currently trying to reduce the storage space of a 80 GB SQL Server 7.0 database. One Major work i am trying to do is to convert all the datetime datatype columns to smalldatetime and all numeric datatype columns to int. Since 30% of the columns in the database have columns of...

How do u implement security for the Shadow Folder. The VSS DB i am handling has some 40 Domain users. I have created shadow folder for all the projects in the DB. I want to ensure that the Shadow folder cannot be accessed directly, eg From the explorer or dos prompt. But as of now i am giving...

I have a database with name IE2.4 on SQL 7.0. When i try to run Import/Export wizard on a table on this db, i get the following message : Error MSG : Error Source Microsoft OLE DB provider For SQL Server Error Description : Unspecified Error Could not find server IE2 in sysservers. Execute...

My SQL Server Database (SQL 2000) Sort Order is : -------------------------------------- Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data I Create a table and...

Hi Is it possible to give the right to execute KILL command to ordinary user. The User should be able to kill only his own processes. The User should not be added to any Server Roles. Is there any WorkAround ? Thanks Thiagu