Hi everyone, I often move databases from home to work whilst developing. I'm always faced with the choice of who to make the owner of the database when reattaching. I normally make it SA just for ease of use but I'm wondering what best practice dictates? Should it be the user I've created ...more >>

Hi I want to implement security based on permissions for groups. So administratorsusers have access to all rows of a certain table/view whilst users with less priviliges have access to a limited amount of rows. I was thinking storing the tablecolumn + value in a table and then updating the ...more >>

I am trying the export data function on regular job.. how can i export data to different file name based on the date or time? currently, it exports to the data and archieve at the same file. ...more >>

I have a database that was created in SQL Server 2000. Would there be any issues if I used this database in MSDE? Does anyone know of any document regarding this? All the articles I have read talk about MSDE databases being compatible with SQL Server 2000. None of them discussed the reverse case...more >>

Hi, I have a very strange problem. I have one sql 7.0 box, and one sql 2000 sp3 box. An ASP app that we've been running off of the 7.0 is now running about 10x slower on the 2000 box. The 2000 has more ram, faster processor, and both are running on WinNTsp6a. I have checked all the possib...more >>

I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why? Any help? ...more >>

When client side connect to the sql server using sql client tools, they see that error. "Warning:The client and server codepages do not match. some ANSI character mappings may not be possible" is it the problem on charcter set? in sql server, it is english OS/sql server in client side,...more >>

While I unistall ,it showmesage "Unable to locate installation log file 'c:\MSSQL7\Uninst.isu'. Uninstallation will not continue. then I try re-install SQL Server 2K , 7.0 , or MSDE , or personal Edition , they all cann't be intalled . please help me , thank You....more >>

Question: I just completed an install of SQL 2000 with service pack3a on a Win2000 OS with service pack 4. During the install I chose per seat license option. After the install I used the SERVERPROPERTY statement to obtain the LicenseType and the result came back as Disabled. I looked in my C...more >>

Hi, I set my SQL Server Audit mode to "All" and now my event log file is almost 12 MB. THe Enterprise manager does not open that log file to view it. I changed the Audit level "Failure" But as I found that it does not come in to effect until we restart the SQL services. This is my pro...more >>

Hi All, In one of my servers my log files grow uncontrollably. I have set all the individual databases to simple mode but the logs still grow. I need to do a backup log with truncate only then shrink the files. This is on a daily basis at this point. If I set the databases back to full mo...more >>

When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if however i convert it to char 109 it gives me the full date ie 'Nov 22 2004 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing this ? Thanks in advance....more >>

Setup: Windows server 2003 Xeon dual processors 4gb of ram Raid 5 200gig of space 98used 100/1000 network card running 1000 Microsoft sql server service pak 3 Sql server is set for a min of 8mb max of 3gb network card never runs over 3% used problem is that the server runs processor pe...more >>

On Windows 2000 SP4 Server I have SQL 2000 SP3a installed. On the = Domain Controller Windows 2000 Advanced Server SP2 (currently) I'm asking this question. On that = machine I have Microsoft Office 2000 SP1 installed and plan on putting the Developer CD in. But = I believe Microsoft Office ...more >>

Hello, I am trying to raise an error in MS SQL Server 2000 using the lines if x = 1 raiserror('Error Message', 10, 1) print 'Next Line.' But, on execution, it shows the error message and goes to the next line. (prints 'Next Line') How do I set up the server so that after raising the er...more >>

Hi admins, If there's a system with running replication on it then how to tell which type of replication is that? Where and what should I look at? Thanks you a lot in advance for your input ...more >>

hi all! i have a strange problem with mssql server 2000 sp3a on win2003 server. i have an import table for guests along with the guests table itself. i have a query that is inserting new guests to this table from import. therefore i use a standard insert statement with left joined guests ta...more >>

Hi NG! I wrote a stored procedure which at first deletes 100.000 rows and then inserts 100.000 new rows. There is a huge difference between executing this SP in the query-analyzer (runtime approx. 2 minutes), and scheduling this SP as an Job (runtime > 30 minutes!!!). Why? Whats the i...more >>

Hi Everyone, I've got an .MDF file (database) and an .LDF file (transaction log) that were created using SQL Server 7.0. We've built a new windows server with SQL Server 2000 installed and would like to import the files onto that server. The problem is that we just have the files, the SQL...more >>

Is there any way I can get all the indexes used in a database? I am using SQL2K. Thanks, Bis ...more >>

How can I go about determining the security patch for SQL Server 2000? Scott Yu...more >>

Is it possible to schedule indexing? I am loading the data from flat file to table every day night from a scheduled job. After loading the data I would like to index the table so that search becomes very fast. I am using SQL2K. Thanks, Joan Alex ...more >>

I have a Replication subscription set up on ServerA to push to ServerB and I was trying to set up a linked server to ServerB from ServerA. I got the following error: Server: Msg 15028, Level 16, State 1, Line 0 The server 'ServerA' already exists. So I ran microsofts suggested script at ...more >>

Don't blame me for this table. I am just trying to code on it. The Table has 5 fields in it. I have an resultid, questionID, OptionTextboxValue, SurveyResultID, OptionID The table hold 3 question results from a form. FirstName, email and the third question has an optionID of 1566 or 1577. 15...more >>

I have backed up the SQL database on server X. I have restored that database to server Y. This server was named the same as server X and has the same IP. After restoring the database everything looks fine, until I get ready to create users in the "Logins" section of Enterprise Manager. A...more >>

I created a pretty complicated query that joins a number of tables and pivots a table. When I put this in a view, it takes about 6-7 seconds to run. When I put it into a stored procedure, it only takes about 5 seconds. Is there any reason to NOT put this into a stored procedure? I guess it be...more >>

Hi, My company has an application which runs audits overnight. These are run as stored procedures executed via ADO. The application is written in Delphi. The same stored procedure is run several times with different parameters as there are several different audits run each night. Most...more >>

According to: http://msdn.microsoft.com/library/default.asp? url=/library/en-us/dnsql2k/html/indexedviews1.asp? frame=true "Indexed views can be created in any edition of SQL Server 2000" (Read the Note on the page) and According to BOL: "You can create indexed views only if you install ...more >>

Ok, I've got the tables created, the proc's created (and they work) and everything else is done on the backend. My question is how to do I get everything I've created in the database using a full version of SQL into an MSDE database that I can distribute to my userbase so they can play. Some...more >>

Here is the UDF I am trying to create: ALTER FUNCTION dbo.TieredAccessCounties ( @State CHAR(2) , @SourceTable CHAR(1) , @UserName VARCHAR(30) ) RETURNS TABLE AS RETURN SELECT A.* FROM OPENROWSET('SQLOLEDB','MDWDATA';'sa';'passwordX', 'EXECUTE dbo.AccountFetchCounties NULL, @SourceTabl...more >>

Ok, you can forget my question about "ROW SIZE" I found out that a row can only have a maximum of 8060 bytes. So here is what I need to do. Break my table up into 2 parts. Some data in one table, the rest in another. makeing the table isn't a problem, getting and putting data into it is....more >>

Hi... just wanted to gather some thoughts on the drawbacks of setting the 'Auto_Shrink', 'Auto_Close', and 'Auto_Create/Update_Statistics' db options. Thanks....more >>

I have a vb app that I wrote that saves the info to my SQL database (SBS2003) For some reason (my app have been running fine for a couple of months) My users are getting teh following error when trying to update certain records. "Can not create a row size of 8436 which is greater than the allo...more >>

i'm replacing a server in the next few weeks. the old server has all database files, log files, and error files on f:\sql which is a drive on a san. sql2000 program files are on c: and d:. the new server will have the same name and same IP as the old server. the only difference is new one is wi...more >>

Hi all, I'm having a problem need your help: I can see all properties of datafile (FilegroupName, FileID, FileType, Location, CurrentSize, Space Used) by Enterpise Manager. Please tell me how do I see all those properties by SQL Query Analyzer. I want to know actual space used in data fi...more >>

Hi all, I ran in to this problem yesterday and would like some direction on how = to fix it. SQL 2k, SP3, Win2k Server box. After running a maint plan, the DBCC commands sent the following errors = back. It looks to me like there is a problem with the non-clustered = index on sysfilegro...more >>

I have a strange problem. I have some T-SQL that functions properly in Analyzer but fails when I write the same code into a SQL Job: DECLARE @DateTime datetime DECLARE @DateNoTime varchar(10) SET @DateTime = (GetDate()) SET @DateNoTime = rtrim(cast(datepart(dd,@DateTime) as char(2))) + '/'...more >>

Hi I currently use OLEDB in my C++ application to connect to MSSQL. I am considering moving to ADO.NET. Is there a document outlining the difference between them? Lawrence...more >>

I'm looking for the hotfix mentioned in article: http://support.microsoft.com/default.aspx?scid=kb;en-us;308627 For full-text index reasons I can not upgrade to SQL 7.0 SP4 at this time. Thanks. -- -- Greg D. Moore President Green Mountain Software Personal: http://stratton...more >>

Warning - this is quite a LONG post. Hi all, Anyone got experience using SP_TRACE_SETFILTER? Let me paint the picture - I want to do some tracing in our production environment, and have jobs set up to automaGically run the traces, so I am building the traces in an SP, via SP_TRACE sp's. ...more >>

I have just been asked to explain a timeout error happening on our production app server. Naturally, there is nothing in the Event Logs, nothing in the SQL Server logs, nothing at all ! Is there a way to cature these down at the database level ? SQL Profiler doesn't seem to do it, even if...more >>

Hi All, I want to using T-SQL execute BACKUP DATABASE command job on the SQL Server Agent. But, it occured the following error: My Job Owner is "sa", Category is Database Maintenance My execute command is .. BACKUP DATABASE NorthWind TO DISK = '\\servername\Backup\NorthWind.BAK' The job...more >>

Hi, I've notice that SQLMail is not cluster-aware. To workaround the problem what's the best approach ? Thanks in advance. Vitor ...more >>

Within a store procedure I would like to pump up the isolation level to serializable just for one particular transaction and restore it back to the previous level when it's done even if there is a fatal error, would someone know how to do that? Thank you very much Here is what I thought the ...more >>

I'm interested in any help anyone can give me in having my SQL Server 2000 database (running on a Win 2003 Server) reside in RAM. I'm working on a conversion project and the problem we have is the time taken for the conversion to run. Having the data in RAM for the conversion and then backing u...more >>

Hi, I need to star a job from Query Analizer... Is this possible ? How can I do ? Thanks ...more >>

Hi , when i use query analyzer to create a table , the .mdf & .ldf shld be modified isn't it (i.e it first write into the log and then into the database) ? however, when 1 tries searching for *.mdf & *.ldf there's no date modified as of the day i created the new table but from Enet...more >>

Hi all, can anyone tell me if there is a virus or trojan or something that will completely uninstall my SQL server???? This morning, SQL server working great... this afternoon all of a sudden I can't connect using any method. i get on teh server... and SQL is gone, completly! SQL Standard 2...more >>

This is a weird one.... SQL Server 2000 Enterprise Edition, SP3a, MS03-031 (818). Dell 2650, Dell 220 Powervault (scsi attached), 4GB ram, SQL Server uses ~2.7GB dynamic. About every 10 seconds or so there is an ErrorLog entry...... WaitForChildren: Children persisting. Retry: 56659 The pr...more >>

Hello, I have Windows 2003 Enterprise Edition with SQL Server 2000, I wanna know if SQL Service Pack 3 is a good choice to install o have some problems, because somebody tell me that this realace is not good. If someone could help me with this ;) Cristian gG ...more >>