Today, while working on repairing another issue, I managed to cause an even bigger issue. Of course, I was not smart enough to backup the db before touching it... I have a new instance of SQL Server 2000 running on a Windows 2003 machine. I ran into some issues with logins and, following i...more >>

I have a Windows 2003 server with SQL Server 2000 running on it. The server is performing dual roles as both a database server and a Primary Domain Controller. When attempting to add logins for the server, I see the domain listed twice. This causes any attempt to add a user to fail. I get ...more >>

Hi , Details : i am using sql 2k on windows 2003 server and i have managed to set up the ms outlook and created a profile called "test" I have logged on using the acct that start ms sql services and i have tested in "sqlmail" wif that profile and it's working i.e i see the msg that s...more >>

I restored a 175g database using enterprise manager. It had about 6 transaction logs in the backup set and I checked the point in time restore. I went back and it said DB restore is complete. But the database icon still shows (loading). How do I clear the loading status and be able to acc...more >>

hi i have a table like this EID datejoined DeptID -------------------------------- where Eid is unique , i was trying to get all the deptid which hired new people in last three months(each month seperately ) ie., some thing like DeptId prevmonth1 prevmonth2 prev...more >>

Hi, I have a master database that I am using to import data into while we migrate and upgrade our customers. Once complete I detach and rename the database for my client, attach to their server, etc. However, when I move to import the next customers set of data I delete all records from t...more >>

We are intermittently getting this error on our SQL server. The front end is access and this happens every so often causing the users to have to exit out of access and reconnect. I'm by no means a SQL expert, and our programmer who manages this database isn't sure what it is either, he says it...more >>

I have an update trigger. In the trigger, when column A is updated, I would like the trigger to update column B. Unfortunately, for each UPDATE statement(multiple records affected), the trigger is just run once on the last updated row. What I want is, for each row that has been updated, fire...more >>

If I want to change SQL Server to use a fixed memory size, do I have to stop/start SQL Server...or even the whole server to do so? Thanks. David ...more >>

Hello all, Windows 2000 Log shipping Qu. I have successfully set up log shipping but would like the monitor server to send an email if the servers become out of sync. It seems that the default is only to log the event in the app log does anyone know how to set up an email alert? Thank...more >>

We are in the final tests of running SQL Server on the SAN we are about to deploy to our data center. During QA testing we are noticing a 50% increase in processing speed even though the SAN seems to be configured correctly. Any idea where to look further would be appreciated. Thanks, Bur...more >>

Hi everybody, We have an stored procedure at master database that runs when SQL Server starts up (exec sp_procoption N'sp_ICarDMSStartup', N'startup', N'true'). This stored procedure calls xp_cmdshell for retrieving hard disc information: INSERT #xpoutput EXEC master.dbo.xp_cmdshell "...more >>

After careful reading the MSDE 2000 EULA I still have a question about MSDE license. May we use/distribute MSDE free of charge as a database back-end for our product on customer’s desktops running Windows 2000/XP and servers running Windows Server 2000/2003?...more >>

Greetings ! We have a problem with triggers that are launched for unknown reasons. We would like to use the profiler. (For instance), to trace whats appening in our DBMS. Is there a way to trace the Triggers in SQL Server ? Thanks ! ...more >>

I am trying to ftp put a file to an internet location from a DTS package. Since I am trying to send a file rather than receive it, I cannot use the FTP Task object. Instead, I use a SQL Task object with something like this EXEC master..xp_cmdshell 'ftp -s:C:\SQLFiles\Export\FH_Feed\fh...more >>

Hi Is any way of making a copy of a database (copying the MDF and LDF files) without detaching the database? Thanks Yuelin ...more >>

We've discovered that under some circumstances running SQL queries locally are significantly slower than when running the same payload over the network, but only when hyperthreading is switched on using the same physical hardware. Please also not that in these tests, I've set SQL server to on ...more >>

Hellow World! In what circumstances do we need backing up transaction log? We have a transaction log backup in the middle of the night, when no transaction is taken place because of the nature of the business. I have a feeling that we don't need to backup the trans log at that time, but in ...more >>

I'm using the BCP APIs from a C++ program. Is there a way to set the maximum number of errors allowed as one does with the BCP utility or bulk_insert? Thanks. ...more >>

In an attempt to manage the size of the transaction log , I would like to use the Simple verses the Full Recovery model. Other than the loss of transaction log backup and recovery only to the last full or differential backup, are there any other “landmines” I should consider? Thanks f...more >>

Hi All, I know that SQL server cursors are general a bad idea and the first thing to go when optimizing. They're heavy and slow and generally avoidable. On occasion it can happen that you get stuck with an SP that you need to optimize and moving it to dynamic SQL is not an option (even thou...more >>

Am I hallucinating or what? The pricing for SQL 2005 came out and the Enterprise Editions is 25K per CPU. I seem to remember when we built our current clusters that 2000 Enterprise was about 5K per CPU. But I looked at the MS web site and now the Enterprise version is 20K/CPU. So I looked a...more >>

Awhile back somebody showed me a neat little trick to filter out the stupid dt tables and etc. I am wondering if there is a similar but different trick for procs because I tried running this same query but changed U to P and it did not filter the dt. and other useless sprocs. @"SE...more >>

Can autoshrink be stopped if it starts and is there any control over it and/or way to set in scheduler? We have a customer that has it checked off on their database properties and it hangs up everything else when it runs. Thanks. David ...more >>

Hi all, I am getting the following errors in the event log. Table error: IAM page (1:185442) (object ID 2041058307, index ID 255) is out of the range of this database. Table error: IAM page (1:161784) (object ID 2105058535, index ID 0) is out of the range of this database. How do I ...more >>

Hi all Is there a way to create a script of a database user to see all of the objects that user has access to and what the access is for each object? Thanks Kevin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

How can I force the contents of Query Analyzer's buffer to display to the screen? A stored proc has some debug PRINT statements in it. The proc takes a long time to execute and the PRINT statements don't display until execution is complete. Is it possible to force them to display immediate...more >>

Does anyone have any experience with Oracle linked servers? We are considering using an Oracle linked server to pull data out of an Oracle database into a SQL Server application but our understanding is that a query's where clause issued from SQL server to Oracle is not resoved until the ent...more >>

I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting one major application database. SQL Server 2000 Standard Edition was installed on the server, OS is Windows 2000 Server. Currently with single instance installed, I checked the memory usage using task manager, the whole...more >>

I am confused about something regarding the restoration of the master database. Is this true? 1. In general you can restore master just using a backup after going into single user mode. 2. However, if the master database is corrupt, #1 won't work and you must run rebuildm.exe from CD be...more >>

Hi, I have an already existing DB A, and I created new one B under the same SQL Server registration. I want to transfer DB "Users" from a to B. How can I do that? To make myself clear, I am not talking about "Logins"...more >>

Hi, now we have a server that is running in sql server2000 enterprise edition. For licenses problems we need to desinstall this edition and install the standard edition. Do somebody know if there is a problem in attach the databases that were created in the enterprise edition on the new sta...more >>

Hi All... I am loking into a web based application that will be opened out to the internet... the app requires a SQL backend, and I have it in the back of my mind that if you do that you need to go down the Enterprise version of SQL and licence by CPU.. can anyone shed any light on th...more >>

Hi I have problems writing to a SQL Server database called Event. I get a lot of Timeout has expired. In SQL Server Enterprise Manager, reading the log I can boserve the following messages: 2005-02-26 15:48:03.79 spid11 Analysis of database 'Event' (7) is 41% complete (approximately 6...more >>

I have raised this question previously but now have additional information. We have a SQL Server 7 machine running under Windows 2000 on a HP Compaq Proliant ML370/G2. The system runs fine until 49.71 days (the time it takes for the GetTickCount API to wrap back to 0. i.e. max no milliseco...more >>

Hello, all! I wonder if anybody here has anything to say about my planning to install the latest version of McAfee's anti-virus software, VirusScan, on a Windows 2003 Standard server, running MS SQL Server 2000 (with the latest patches). I've read that some have reported problems with Virus...more >>

Hi I have problems storing data to a SQL Server database. The SQL Server and database is located on another computer than the application writing to it. It has been running well for a long time but a few days ago the application started to report: Error number: 80040e31, Timeout expired.....more >>

Hi, I have 20 sql file which contains functions and procedure, for example test1.sql , test2.sql , test3.sql ..... test20.sql >>I want one file to call the above all files. i can execute one file like this "isql -S servername - U sa - P xx -i test1.sql" so i have repeat this commant ...more >>

We are in the process of purchasing a SAN. We will not be using SQL Failover clustering but we will be using the SAN to store SQL Server databases. Do I need Enterprise Edition of SQL Server or will standard edition do?...more >>

I have to install SQL Server onto a new PC and then restore the data from tape backup to the new server. Are there any special things I have to do...I have never done this before, so I am unsure of the steps... Basically, I will be doing this Setup new PC Install SQLSERVER Make sure n...more >>

Hi world, I get the General Network Error (and sometimes the SqlServer does not exist). I used to get this issue for the past few months. What I used to do is restart SQL Server (from the system tray) one or two times and it used to continue working. I never cared. Now one of our custome...more >>

Hi: Is it possible to create a database and tables which can store multiple language ? I need to create a table with a column that can accept English, Chinese, Japan. Korea and Thai word. Thanks JCVoon...more >>

i have a user test .. through this user i am able to run exec master..xp_cmdshell 'dir' .. but following command is not working exec master..xp_cmdshell 'c:\t1.txt f:' where f: is the mapped network drive What are the settings required to access mapped network drive through xp_cmdshell?...more >>

help! I have a 34 meg db with little activity, at least from an application perspective. the transaction log has slowly and steadily grown over many months to 7 gig!. ent mgr says only about 8 % free. how do I tell where all this is coming from? how can I bring the log back to a norma...more >>

Is it safe to say that an 8 way will run twice as fast as a 4 way when it comes to executing stored procs,etc.. ? Is there a way to figure out whats the best server to obtain and cost justify it . It seems 4 way would be ideal but how do we know whether an 8 way would really be super fast ? ...more >>

I have a WinXP Pro home network which is behind a firewall. Within this network I have 2 computers running SQLServer 2000: my desktop and my laptop. Both instances are configured identically and use Windows authentication. I use Enterprise Manager. - My laptop can "see" the desktop's insta...more >>

Hi , i am running sql 2k on wind 2003 server and i wanted to set up an operator that i can send email to if there's any problem according to the books Online , there shld be a mail icon at the Control Panel but it's not in my computer Ques : 1-a) is it becoz Exchange 2003 serve...more >>

I have two tables that have a one to many relationship (Story and Photo tables). There are many Photos per Story. I'm trying to create a SQL Statement that will return just one row for each story, that also returns the column SlidePath from the Photo table as the third column returned. Here...more >>

How do I use a variable in a TOP statement? For example, I want to programmatically pick the number of values returned so I created a local variable called LimitPicsTo, here is the code: declare @LimitPicsTo int set @LimitPicsTo = 2 SELECT TOP @LimitPicsTo PhotoID, Caption FROM Photo ...more >>

I have a windows server running SQL Server Enterprise. Can Advantage Database server be installed on the same server ? Will it be any performance issue for running both different database engine ? ...more >>