I recently deleted the default database, which stopped the Authentication. I was able to change the default database to the active database, but now I can no longer switch to Windows Authentication in the Registration. It only allows me to use the sa. Now I have a DAP that cannot be viewed by pu...more >>

Will it cause any slowness to the stored procs while the shrink is going on ? Will it hold some locks ? ...more >>

I have a rather complicated query statement in a stored proc which all of a sudden hangs in production. I copy the same database to QA and run the stored proc and it executes in less than a second. The explain plans are different between production and QA. I have recompiled (sp_recompile) the sto...more >>

I have a sql server user account that periodical loses permission to groups and db_datareader access to several databases. What is easy way to determine the process or stored procedure that is changing the permission on this sql server user account. I would to complete this task without us...more >>

For example, I have a variable @SQL = 'Select ''Hello World''' How can I execute this @SQL in stored procedure? Sorry for newbie question =] Thank you. ...more >>

Hi All As SQL Server 2000 is only 32-bit (except for the Itanium edition) will SQL Server 2000 suffer any performance degradation as a result of being installed on Windows Server 2003 R2 Standard x64 Edition? Thanks...more >>

I am trying to use a IN statement Select * From ShowMenusFirst WHERE (Security In ((select Security from Users Where (Username='mkintner')))) ORDER BY Menus.Level; The results from the query select Security from Users Where (Username='mkintner') is 'Low','Med' I wanted the IN Statement ...more >>

Can you please confirm my understanding of TempDB: 1. TempDB is in Simple recovery and therefore the TempDB log (.ldf) is primarily used for rollback purposes. 2. The TempDB datafile (.mdf) is where temporary tables, temporary stored procedures and worktables are built. 3. The TempDB data...more >>

If I execute the following statement on a nonclustered index there is no reduction in fragmentation on the index: DBCC DBREINDEX ('DBName.dbo.MyTable','IDX_MyTable_NonClustered',0) WITH NO_INFOMSGS The table on which I am performing the above statement has a clustered index. Is that the rea...more >>

Hi All, Recently a strange behaviour was seen with Enterprise manager. When we change the Windows login password all the registrations of SQL Servers are missing from SQL Server Enterprise Manager. Did anyone faced this situation before? Its really painful to register 20 servers each t...more >>

Just thought I would pass this along in hopes that it can help someone. When I had changed the startup parameters for SQL so that the databases and log files would be in different locations. I used CAPITAL LETTERS to designate the default location. Like -DD:\data and -LL\:logs... that cau...more >>

Hi, It's a repost of an old thread with more information included I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've been trying to link a sql server 2000 SP4 to this but I'm having some troubles. When creating the linked server from the Sql Server Management Studio/New...more >>

Where do I put the if statements. do I put them after select or after from or after where. Or in one of those areas. Not sure, never used one before. ...more >>

Hi, We've got some staging and fact table loading processes for our BI datawarehouse wich launch heavy queries. After applying SP4, some of these queries/processes perform until 10 times worst, and are "apparently" self-blocking in the SQL Server activity snapshot. System configuration: ...more >>

Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with COM objects Thanks ...more >>

Hi, I would like to send a SNPP message if the data I am going to insert on the database meets certain criteria. I notice that there are a couple of vendors with SNPP objects (.NET and COM) I am using MSSQL 2005. The data is send to me (SQL) by another software that doesn't know that it n...more >>

I want to recover data in a table on SQL 2000 server. This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file contains the data of the table. I made detach the database. Can I use one old backed up .NDF file replace the current .NDF file, and together with other current files...more >>

Hi, ya-all. That's basically my question in a nut shell. Can it, and How do I set it to ? Thanks. ...more >>

Can you run a query that will return only results that have the data in a target column duplicated in another row? i.e. Duplicate address data Result data: RecordID Lastname Firstname Address ------------ ---------- ---------- ------------------- 4 Jone...more >>

I have a stored procedure which I want to view the results in a specific sorted order, however I do not have control over the stored procedure as it has been created with the ENCRYPTED keyword. I tried to use the INSERT tablename (columns) EXE storedproc syntax, but I get the error about using...more >>

Hi everyone, I need your expertise to find the best way to do the following: - I have a datawarehouse in Sql 2000 (over 200 Gb of data) with many Dts (over 75) running daily via a Sql Server Job to load different data sources. - I have a brand new server where i've installed Sql 2005. - I ...more >>

I have a server running Windows Server 2003 with two instances of SQL Server 2000 - a default instance and a named instance I shall call "INSTANCE_A". Locally, SQL Server works correctly. Query Analyzer connects to both instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the ne...more >>

How can I split a large database in SQL Server 2005 into many parts? ...more >>

Hi, Can I safely update the syscategories table without any impacts to any dependencies, if any? I have created a number of similar type jobs and would like them to be categorized so that I can distinguish them easily. TIA. Regards,...more >>

Hello All, The last time I needed it, there was a CTP for the new SQL Server 2005 Express Manage. Can someone let me know where to find it now? Thanks for your help :) -- Bob Hanson Senior Solutions Developer ...more >>

Hi, Is it possible to examine which queries are performing table scans and which ones are doing an index scan without going through the execution plans? I am asking this because, I have been given a few databases by my manager and he has asked me to identify all queries that perform a tabl...more >>

A user needs to run SQL Profiler, how can enable him to run this tool without assign admin rights? or Any alternative way? Thanks. ...more >>

Hello, How can I find out from SQL SRV2000 which characterset and collation is used. Thanks -Will ...more >>