If I have an account table where the column "accountno" is an identity i.e. auto-generated, and I insert a new row like so (sorry, but all- caps keywords are so 70s): insert account values (20000.00, 42) and then want to do something with the newly created account rows accountno, like inse...more >>

hi, I'm building a bulletin board and each message should have its own id. what is the best data type in that case? I might have over 1000 messages a day, for now I chose bigint. Any other options? Thanks ...more >>

Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is my own (Vista) and the other is a company laptop. I can't synchronse using a network connection between the two...more >>

hi, i'm apung from indonesia. i have a problem when i was updating my windows using windows updates. there was a notification said Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) can not be installed. please help me. thank you -- apung01...more >>

Is anyone running large sql server 2000/2005 databases on VMWare ESX? Any comments / tips about configuring for best performance, best hardware, and stability, ...? I already presume that database files and logs are on a separate File Storage system such as SAN. Thanks ...more >>

Do we still need to put a cap to the max server memory settings for SQL on a 64 bit machine or just leave it to the default ? ...more >>

Hello, I am new to SRS. So this is a new-be question. When creating a new report in visual studio. When creating a new dataset. Do you always need to create a query string to retrieve the fields that can be used on the form? Is there some SQL picker query builder. Where you can build a query...more >>

IDkey| ColA| ColB| ColC 100| A12693| 1528602| 132.56 101| A12693| 1528602| 132.56 200| A13823| 363985| 52.12 201| A13823| 363985| 52.12 300| A23234| 435675| 12.14 To pull out the dups, I can use: select cola, colb, colc, count(*) from table group by cola, c...more >>

SQL Server 2000 cluster While trying to move the master, model, etc db's I put trace flags into the startup according to the instruction in: http://support.microsoft.com/kb/224071 When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get in to change i...more >>

dies with event log message from .net 2.0 runtime "failing application dtexec ...kernerl32.dl...." others have reported this but i have seen no resolution...more >>

Hi, if I always store less that 90 characters..... is there a storage or performance panalty.... if I set the size to 2000 or MAX? Thanks for your help Nalaka ...more >>

i have server1 server 2 is linked to server1 server 3 is linked to server1 all sql2005 on server1 i go select foo from [server2].[db].[dbo].table where bar like '%ff%' union all select foo from [server3].[db].[dbo].table where bar like '%ff%' by looking at the execution plan I can see t...more >>

Or stage environment has "only" 2gb memory while the production has 8gb. We have a couple of large tables in the DB that is around 1-2gb large. We are noticing that when you make queries against these big tables we get timeouts the first couple of times and then it works. I have also looked...more >>

I need to move SQL 2000 with approx. 400 databases and about 1 TB size to new hardware, plan is to build server and then install clean SQL 2k keep same SP level on OS and SQL side, keep same drivs and paths to make it simple, my question is about security. From my past exp. I know that moving ...more >>

I am building a new server. What is more important with respect to query speed? The transfer rate of the drives or the access time? Thanks for any info you can supply....more >>

I'm trying to create a login called am\samchicrm002$ in SQL 2005. I get the following error "The server principal 'AM\SAMCHICRM002$' already exists." I have dropped and try to re-add the login but nothing works. I'm not using Kerberos. Do I need to? I just want this login to work. I ran select...more >>

hello, I am trying to figure out how to draw a 1:1 relationship in a database diagram (or with foreign keys) from visual studio 2005. in the books online it explains one-to-one relationships and even shows one in a screenshot, but I haven't found any way of creating them TIA Andy ...more >>

We attempted to restore a database to a new name via EM (2000) and it errored. Now, in the database list it shows as "(Loading...)". I believe restarting the instance will clear it, but I was wondering if there is a way to clear it that doesn't involve a restart. ...more >>

Hi, I would like to implement the log shipping for our SQL Server 2000. But in the Add Destination Database screen, only the source database server name in it. I can't find or type in the destination server name. What could I have done wrong? Thanks for help. Jason ...more >>

Please could you help me to determine why a BAK file can be refused by sql server when calling a recovery process I Allready have these ideas - Other version of sql server making BAK file than the recovery one (or... not a real BAK file !) - BAK file altered on file system (disk problem...)...more >>

If I have a database Fred and I want to restore it on the same machine as Fred2, how do I do that? I know I can specify the files it restores to I just have a memory the last time I did it that it said you can't restore to the database with a different name. TIA - Jeff. ...more >>

Using SS2000 SP4. When I run DBCC SHOWCONTIG (ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES I get an error "Server: Msg 2501, Level 16, State 45, Line 1 Could not find a table or object named 'ActionsNeeded'. Check sysobjects." All objects in the database are owned by "memsym". If I try "D...more >>

I haven't tried this yet so forgive me. But are there any issues with taking a database on SQL 2005 and putting it on a machine that only has sql 2000? I know when you attach the 2000 DB in 2005 it does some type of upgrade - is there a cooresponding "downgrade"? Darin *** Sent via Devel...more >>

Using SS2000 SP4. Is there any way to back up to a .bak file just selected tables from a database? Thanks, -- Dan D....more >>

WE have just upgraded our database from sql 2000 to sql express. Nowthe asp.net code doesn't work. I tried many different things, no luck. Please help! thanks very much. Here is the connection code: conn = New SqlConnection( "Server=xxx.xxx.net,1433; UID=User; PWD=lxxx2007;Database=mssql3"...more >>

Within a transaction, want to be able to log errors to an activity log table but if errors occur and a ROLLBACK is invoked the errors logged to the activity log table get rolled back also. What's the best way to handle this situation? ...more >>

How can I ensure the query plan that I see through my management studion sticks to the sproc irresepective of where its called from ? I dont want it to change. I know there is plan guides.. How can i do so ? I can see the query plan using display estimated execution plan and I guess i can u...more >>

Hi, My company has a SQL Server 2005 standard edition used for storing some log information. The log is only used for some BI reports, and is not part of our critical db's. The server has pretty much been running on its own, and my colleagues and I have not given it the attention that was n...more >>

I want to figure out how deep the index tree is from the root node.. And want to get a feel of how the index structure actually works and whats in every page of the tree for a table starting from the root node. Say i have a table with just a clustered index on it. And as i start inserting ...more >>

Can I do a diffenential Backup on a simple recovery mode Database? ...more >>

We had a server with SQL 2000 on it. It had two instances. Worked great. We decided to upgrade to SQL 2005. We ran the upgrade on the default instance. Everything was great. Before we upgraded the second instance, someone went into 'add remove programs' and removed the second instance o...more >>

If there a way to detect if backup fails? I like to add better error handling... I need to be able to run using a script not thru the Sql Scheduler. DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for...more >>

SQLServer is the Database. GUIs show Login name. Sometimes the login name changes to 'Login #' ... like 'Mary 2'. What might make this happen? ...more >>

We are planning on upgrading our production environment to SQL server 2005 64 bit on 64 bit servers. Will we need to upgrade the target servers that we are replicating to to 64 bit also?...more >>

I work in asset management and am looking for a solution to identify a sql server version and edition from the command line. We run 300+ SQL servers with multiple versions and editions so a manual tracking system is not ideal. The MS article requires running sql statements against the server but...more >>

We are a pretty small sized company that has one sql server that also serves as our application server. We backup our server to a tape drive nightly using Veritas. We have a Dell PowerValut 110T. Starting about two days ago (much to my dismay) backups started failing. We have 3 main SQL Se...more >>

I am working with a client who has a badly programmed application. Every so often the database will stop responding and it seems to be caused by locks in the database. Is there a global setting for lock timeout? Is there a process that I can run to look at locks and auto expire them after...more >>

I want to move the system databases and tried following the instructions from: http://support.microsoft.com/kb/224071 (How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server). It didn't work. Adding the startup parameters "-c -m -T3608" does no...more >>

Hi, I have problem in BCP utility while exporting data to sql server. It works in my system and my friend's system , but it gives the following when its run in production server. SQLState = 22007, NativeError = 0 Error = [Microsoft][SQL Native Client]Invalid date format SQLState = 22007, Na...more >>

SQL 2000 - How can I identify transactions that take longer than X seconds to complete and the TSQL statements that make up those transactions?...more >>

Is there a way to tell how much of a transaction log file has open transactions? For example: You have a 10 MB transaction log that is 50% full ( DBCC sqlperf(logspace) ) and you backup the log. After the log backup you see it is 25% full. Therefore, 25% of the transaction log held open t...more >>

One of our servers is running 9.0.3054. I created a simple maintenance plan of 3 steps within a single subplan: (1) Full Backup all databases daily (2) Maintenance cleanup task (on success of 1) (3) cleanup history task (on success of 2) steps 1 and 3 run just fine. Step 2 on the other ha...more >>

Hi all We added /3GB /PAE to the boot.ini for sql 2000 SP4 on the Windows 2003 R2 SP2 standard server with 4GB RAM. Is there a way to know whether it utilize the 4GB RAM better with /3GB /PAE switch? Thank you...more >>

Where can i find differences between SQL Server and MYSQL ...more >>

Hi, I have problem in BCP utility while exporting data to sql server. It works in my system and my friend's system , but it gives the following when its run in production server. SQLState = 22007, NativeError = 0 Error = [Microsoft][SQL Native Client]Invalid date format SQLState = 22007, Na...more >>

Hi All I have 2 SQL Server 2005 Ent X64 servers. Neither of them is running reporting Services or has it installed They are both (in theory) identically configured. However ... One has a Green reports button in the Object Explorer Details panel the other doesn't Neither has a reports contex...more >>

Installing SQL 2005, how can I specify what volume to put my Data and Log files on? I do not see the option. thanks Rick ...more >>

Question/sanity check about BULK INSERT performance. I load a 300,000 row text file into my largest table every day. The file loads into an empty table with the same structure and defaults but no indexes in about 10 seconds, for a rate of 30,000 rows/sec. The same file takes more like 3000 se...more >>

About once a month I receive the follow error from my weekly DB Shrink job. I have always run a DBCheck afterwards and the database is clean. I have searched the web and MS but have been unable to find any detailed information on this error message. Any help / comments would be greatly appr...more >>

Hi all, does anybody of you know a system view or something similar which returns, which database was the latest one attached? I'm trying to write a little SP to change the default default logsize / growth rate for the latest attached database and therefore need to know which one it is. ...more >>