Hi, We intend to get a new Windows 2003 standard server with 8GB Ram. We will also be installing SQL 2005 standard on the same system. We are aware that Windows 2003 standard server supports up to 4GB Ram and SQL 2005 standard support up to the maximum ram the server has. Our question i...more >>

I need to learn how to transfer some table objects from a local instance of an SQL2K server to a local instance of an SQL2005 server. Is this possible? <%= Clinton Gallagher ...more >>

I have a problem with Microsoft SQL Server 2005 Express, My web application runs fine on my development PC, but when I copy it to my server (My server is running Windows 2000 Server) and try to access it from the web I get following error: An attempt to attach an auto-named database for file...more >>

Looking for suggestions about what I might look for.. During periods of time when no INSERTS are taking place, SELECT statement durations are around 16-30ms for hundreds of requests per minute. When there is a batch of INSERTS that are sent to the table via SP that number in the many thous...more >>

Hi, what is the licensing model for a development purpose? I have 1 dev server and 10 developpers with all the admin & dev console installed. Which version of SQL Server is required? Can I install SQL Server dev on my server and give access to all my developpers? I don't see any price...more >>

I just noticed there are two of the server listings ( original list and revised). Please forgive for reposting, not sure if 1st post will post here also Hello All, I have sql2k EE. I have a table named INVENTORY. It has two colums partno cost 1 0 2 0 3 ...more >>

Hello All, I have sql2k EE. I have a table named INVENTORY. It has two colums partno cost 1 0 2 0 3 0 2000 0 Currently there are 2000 partnumbers in this table. All the partnumbers have 0 in the cost field. I want to update each part nu...more >>

is there a function which does cumulative in SQL Server 2000 Thanks...more >>

Hi - Trying to chase down a baffling performance issue. Our database has been running very slow lately. So we are performance tuning the database. In doing so, we created a copy of our production database. In that database, I changed one clustered index on a table to try to improve performance...more >>

I am experiencing some strange behaviour when I try to insert rows into my SQL Server 2005 DB through ODBC. I use MS-ACCESS ODBC linked tables to insert rows into my SQL Server 2005 db. When I insert a row into a linked table (by typing data into it) the row "disappears" and is replaced by...more >>

Trying SQL Server Management Studio Express I'm missing any view or access to stored procedures. Any ideas why they don't show? ...more >>

I have a SQL Server 2005 instance installed. I have created databases and schema on the SQL Server. I cannot start the service for the SQL Server. I ahve tried using every account possible. It always errors out with the following message: initerrlog: Could not open error log file 'C:\Progr...more >>

Looking for what permissions to set for user to allow them to create databases change/write/modify/edit only those databases. add logins for only their databases Thanks for any help. ...more >>

I am looking to set up automated scraping of SQL Server logs to notify me of serious problems with the server. Is there a list anywhere of common/serious/all messages that SQL Server might log to the Event View or its own log files? ...more >>

Customer is trying to restore a backup of their database. SQL Server gives the error: Cannot use backup file %s. Originally formatted sector size 512 and now device sector size 2048. Only one guy (in Germany in March 2000) has ever seen this error. And he never got a resolution. ...more >>

I need to change the server name of my SQL Server to one of a current SQl server that is being decomissioned since the newer server is faster, more disk space, etc. Do I need to do anything with the named instances on the server I am renaming, as i want to make sure that System DSN's and such ...more >>

sql2k sp3 I have a report query that sometimes runs in 3 seconds, other times I kill it after 10 minutes. When its taking a long time, there is no no blocking, no extremely high cpu/ memory usage, no huge amount of activity. Something I just noticed though is that someone put the Clustered ...more >>

Has anyone had any issues with a database doubling or tripling in size after SP4 is installed? We have several databases that are structurely the same however certain DB's have grown enormously in size without a large increase in data. Whenever we try to shrink the Database it won't shrink to ...more >>

Hi, I was asked to look at server running Windows 2003 Standard (Version 5.2(Build 3790.srv03_sp1_rtm.050324-1447: Service Pack 1), Quad Xeon processors, running 4Gig of RAM with a 33Gig OS drive and a 1.5 Terrabyte Data array partitioned into a 1 terrabyte partition and another .5 terraybt...more >>

Hello, I like to debug stored procedures, but the sp_sdidebug extended stored procedure is missing on my server (master database). How can I recreate this procedure? ...more >>

When I run the command below on SQL Server 2005 box I get the following error. exec sp_CreateStats 'fullscan' Msg 15600, Level 15, State 1, Procedure sp_createstats, Line 27 An invalid parameter or option was specified for procedure 'sys.sp_createstats' The same command seems to run fin...more >>

Hi, I have a server that has sql server2000 sp3 on win2000 server sp4. On this server every day runs a process that take about 3 minutes to finish. But once a month it takes about 30 min. or one hour to finish. At this moment the only thing that help us to fix the problem is to restart the serve...more >>

Hi Group, in the table syspermissions, the column actadd and actmod holds the statement permissions when id = 0. The columns contain combined bitmapped values for various statements (or object permissions when id > 0). But what is the value 256 for? I found the other ones but only not th...more >>

Hi all, I have the following environment: SQL Server 2000 SP4 (4 Processor, 8 Gb Ram) Windows 2000 Advance SP4 with PAE 10 Gigabyte Database 300 Computers Connected using MS JDBC Driver 24X7 environment Server had been running for 8 months with no problems Database is purged weekly Databa...more >>

Hi, I got this error for log backup. 'Test_log_Backup' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. Any ideas? T...more >>

When I switched to a multiple processor SQL Server 2000 machine, some of the more complex queries produced this error (http://support.microsoft.com/?kbid=837983): Msg 8650: Intra-query parallelism caused your server command (process ID #50) to deadlock. Rerun the query without intra-query ...more >>

Hi Freinds, I am very new to SQL Server and i have to upload this spread sheet and the reocords in this spread sheet will go to fields of already existing record in the sql server table. I am confirmed that i have to write some kind of query to do that but i am unable to write this query so fa...more >>

Hi there I'm running SQL Server 2000 SP 4 (8.00.2162) Standard on Win 2003 SP1, 2GB RAM, dual 3.00 GHz hyperthreaded processors. I get the above message intermittently - up to once a week. I have to kill the sqlservr.exe process to enable SQL Server to restart (or reboot). I cannot connect ...more >>

Hello, Does anybody know how to migrate form Mysql to MSSQL 2005? I tried creating DSn`s for repective database butin the DTS wizard My sql is never selected as a datasource. thanks, Sap ...more >>

SQL 2000: I have a DB maintenance plan where one step rebuilds indexes. I get the following entries in the text log file that the step creates: Starting maintenance plan 'CDW Backup' on 2/13/2006 1:00:02 AM [1] Database cdw: Index Rebuild (leaving 5%% free space)... Rebuilding indexes...more >>

Hello, I am trying to create DDL trigger as below ALTER TRIGGER DDLTRIGGER ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS AS DECLARE @EventData XML SET @EventData = EVENTDATA() INSERT DDLEVENTLOG (EVENTTYPE /*POSTTIME, SPID, SERVERNAME, LOGINNAME, DATABASENAME, SCHEMANAME, OBJECTNAM...more >>

Hello everybody, last week I had to move my master database en with it the location of my SQL Server errorlogs. Since then new errorlogs are created in the new location specified in the startup parameter, but in EM I can only see the archived ones, not the current. Turns out that xp_enumerror...more >>

I am trying to write a query to find the currently logged on users to the SQL 2005 Server. Now the problem is 'sys.dm_exec_requests' shows the database name only when the process actually starts the execution. I need to find the session-ids of all processes along with the database names th...more >>

HI, I'm looking to start a project where I will be building a CRM type package with the intention to sell. Can anyone clarify how the whole licensing thing works with SQL Server? Do I buy a developer licence and then I can redistribute the server software? Would my client need to by CAL...more >>

What sort of problems can I expect when moving my SQL 2000 databases to the SQL 2005 platform? Must there be an adaption of code for some of the objects (sp, view, udf etc), or will it work fine when I put the database compatibility level to 8.0? -- MCDBA 2000 MCSE 2000 ...more >>

We have been getting timeouts intermittently with our application. The time out expired appears to be a random occurance and we are not able to replicate the issue on a consistent basis. In most instances the time outs are happening with SELECT statements and after a few minutes it seems to go a...more >>

I hope someone here can point me in the right direction. We currently have a "Live" server and a "Backup" server both using SQL server 2000. We are trying automating the database restore between these servers if possible. It is currently being done by hand. We have 40 Databases to recover....more >>

hi all , i've got an application with sql databse. it runs correctly on the server. when i go to windows Xp and installed the appliaction and run the sql enterprise manager to connect to the server, i get the following error: message =: ExecuteReader requires an open and available connecti...more >>

Hello, In MySQL we can set to allow a user to login and access certain table from certain host, is there anything close to that in MSSQL 2000/2005? Actually, we just need to control certain users unable to use the Domain Creditial to access certain databases/tables except i...more >>

Hi all, Is there a way to integrate with Visual SourceSafe? Since i want to keep track the changes of functions, sp, schema... etc. Thanks Martin ...more >>