Hi all, I realised that there are many postings regarding this error, however, I have tried all possible proposed solutions based on the replies for the past 24 hours trying to solve this problem, but failed. Frustrating it is, but I hope you guys can help me with this. Problem arises when ...more >>

I am running SQL Profiler against a simple stored procedure and am recording RPC: Completed to get the duration of the procedure. This is working fine but I need a little help with what this really means because I am seeing variance anywhere between 13ms to 6000ms. I am assuming that the dur...more >>

Is it possible to create a view on one SQL server and add a table to the view from another SQL server? Tim ...more >>

We are experiencing a non-deterministic (ND) problem. It is happening regularly, but not consistently. We run a suite of tests for performance evaluation. Some of the tests insert data into empty tables, and later these tables are read. Each time we are able to reproduce the hang, it is becaus...more >>

We are trying to run a load test on analysis services 2005. We were going to start with 30 different databases out there and see what the processing loads were. Analysis Services is stopping us at 25 databases and telling us that there is no more room. We have 260 GB free on the server. Has ...more >>

Hi guys I am using the Bulk insert command to import a flat file to the SQL server 2005. My flat file contains about 1 million rows. I have already created an empty table to insert the rows from the flat file. But I dont want to import the first row into my table in the database. Is there a...more >>

So, if I have just inherited an un-documented database and want to determine the relationships, is there a nice sproc or ext-sproc to do that with that delineates the different relationships? ...more >>

I was curious if I could get some opinions on this. We produce pay checks in a payroll system by running a stored procedure to calculate the payroll, write the check rows to the paycheck table and return the recordset of checks to be printed from that table. We use our own report writer ro...more >>

I have SQL 2000. I have one table tmpJcrewUpdates and another table Jcrewupdates. I have a task that reads a text file and imports all of it into tmpjcrewupdates. The floowing script I am try to get it to either update exsistign information in Jcrewupdates if the REF# is already in teh ...more >>

How to find out which application is issuing "DBCC traceon(2861)". We see a lot of messages in sql logs that the flag is being turned on. I tried sql profiler with a filter on textdata column to look for "DBCC Traceon" but, didn't find anything. We use MOM and Quest Central for monitoring. ...more >>

I just setup two new SQL 2005 Stnd x64bit servers for a customer. The original two servers running the same SQL version have been running fine for 3 weeks now. The mian production database is attached and SQL seems to be working fine. When I try to create a new Maintenance Plan or use the Maint ...more >>

Hello, My question is about database partition. I know how to define a filegroup, Partition Function, Partition scheme and do a partion on brand new table. But my question is how can I partition a existing table without droping it!! Thanks for help Hooman ...more >>

I have a really simple question, I am sure, but I am drawing a huge blank. All I want to do is go into my table called STATUS_AND_DATES and change the field called JOB_STATUS. I want to change all the records in that field that say 'For Sale/Lease' to 'For Sale'. How do i do an update like that...more >>

Hi, All SPs I created, the ownership were DBO. Now the ower is my windows ID? Don't know why and how do I change backup the DBO instead of my ID. Thanks ...more >>

I am getting the following error when trying to move it from E: to F: drive. udopen: Operating system error 5(Access is denied.) during the creation/opening of physical device F:\SQL Server\Data. The domain account that runs the SQL Server services is a local admin on the local SQL Server c...more >>

When detaching a DB (command line or GUI), NTFS existing permissions on both ..mdf and .ldf are removed and replaced with my userID (having full access). Attaching database removes my userid and creates full permissions for two groups (local\administrators and local\Sqlserver2005mssqluser sv...more >>

I am using CRM with SQL 2005 database on one box and Great Plains with SQL 2005 on another server. I have 30 clients who will access CRM and Great Plains and SQL server database on both the boxes. Do I need seperate licenses for both the SQL server or I can access both the servers with single ...more >>

I have a SP that creates temp tables then does a call to another SP to insert data into one of the temp tables like: insert into #TEMP EXEC dbo.database.rptsel_stored_procedure When we execute this SP when it gets to this step it opens a transaction on tempdb and keeps it until the insert ...more >>

Hello... Is there an easy way to get a csv or txt list of all contraints? As well a list of indices for a given database? Thanks in advance Anthony...more >>

I was looking at setting up multiple SQL Server 2005 Standard edition servers using Peer-to-Peer Replication with the goal being able to reindex one server at a time so as not to have any downtime (via locked tables). Would this work? Also, I know log-shipping to a standby server only require...more >>

Hi, I have a very weird situation here. I have a table that keeps the quantity for one of our stores. It consist simply 3 colulmns: product_id, quantity_on_hand_in and the rowid(). It was well synchronized with the local server until one day, that store caught fire and the local server is ...more >>

MSSQL2K5 SP1 Im reading in BOL regarding Linked Servers: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9e302c29-639d-4509-ba1e-cf45 2582c5c3.htm and it says: Requirements for the First/Middle Server (SQLSERVER1) a.. The server must have an SPN registered by the domain administrato...more >>

We are using SQL Server Enterprise Manager to connect to all of our SQL 2000 servers - one server, one box. Now we have a new box running SQL Server 2005. Is there anyway we can make a connection from a SQL Server 2000 box to SQL Server 2005 box? We need a way to 'see' the new server from the ...more >>

I have a customer using SQL Server 2000 Enterprise Edition on two clustered servers (Windows 2003 SP1) with the following spec (times two): 4 x Intel Xeon Processors @ 2.7GHz 3.5GB RAM 36GB Local Hard Drives 175GB of SAN space for Data and log files The database is around 2.5 GB. They d...more >>

I have installed this software: - Windows Server 2003, Enterprise Edition. - SQL Server 2005, Client tools (Server is in an another machine) - VirusScan Enterprise 8.0.0 When i execute the next query: USE AdventureWorks SELECT * FROM Person.Contact WHERE ContactID = 1 FOR XML AUTO Vi...more >>

I've created a number of .html, pivot tables using Access' Data Page tools. These work great and by pointing my browser to these files, users throughout my firm can access these pivot tables. I had assumed that I could simply publish these pivot tables on the web to outside users who are confi...more >>

Sorry, this is a repost of a few weeks ago. The thread died without any responses. ===== I have a customer using SQL Server 2000 Enterprise Edition on two clustered servers (Windows 2003 SP1) with the following spec (times two): 4 x Intel Xeon Processors @ 2.7GHz 3.5GB RAM 36GB Local ...more >>

I detached a SQL Server 2000 database and attached it to to a SQL Server 2005 server. Everything seems to have upgraded fine except I have many database users that are not associated with a SQL Server 2005 login. Some 2000 users may map to a SQL Server 2005 login of the same name and some ...more >>

Hi all, I'm having problem with the step that runs from application which is programmed by a company. These days on certain step which is using sql server database while application is running through a scheduled process it is just stoping in one certain moment. I can not locate the problem s...more >>

Hi, I was wondering if something like this is possible in sql server 2005... Say you have a table with 100 columns each called COL1, COL2, COL3....COL100 can you cycle through them using a variable column name and a select statement? What am I doing wrong? DECLARE @colnum AS INT, @colname AS ...more >>

Hi all, Our custom application run on SQL Server 2000. On random period of time (but quite often lately) users get timed out, and when we checked the server resources utilization, the utilization is so hight, so that only 80 MB out of 1 GB memory available. But we do not know what makes the s...more >>

I want to create a vb script which will check for encryption on my documents folder and email me if the folder ids not encrypted. Has anyone done anything like that.This shuld be a VBS file. Any ideas are welcome.I want to schedule it using the nt scheduler. Thnaks Ajay ...more >>

I'm trying to get a return value (MyResult) from a stored procedure that's called from within an ASP page. Both the codes in the Stored Procedure and in the ASP page are rather simple and straightforward. Any help available? The error code says: Microsoft VBScript compilation error '800a0...more >>

Hi Group, I have a question in SQL Server 2000. The question is, I have a table with 2 millions of records and I want to fetch the record from 200 to 400 rows and the table doesn't content any identity cols nor any numeric col all the varchar field. Can you put some light on it? Regards Ariji...more >>

MS SQL Server 2000 Enterprise with SP3a Is there a way to known which process is causing 100% cpu. Is cpu column in sysprocesses gives that. How can we see the plan of current running process. Sybase has sp_showplan. Is there any equivalent stored proc in sql server. Thanks. Satwinder.....more >>

Is it possible to install MS SQL 6.5 on Windows 2003? Can you give some information if it is possible by some Patches or MDAC ? or any spesific SP? Thanks Suhas ...more >>

Hi All, My problem is that I have to iterate a procedure on several db ... db names are known at runtime. I tried "Use @dbname" without success. Someone can help me? Thanks in advance. Freddy ...more >>

Hi. I found this misleading issue and thought I would share it. We set up a maint plan on a SQL2005 RTM box to rebuild our indexes with a fillfactor of 90%. After the plan ran, the database grew by about 70% and the fill factor was actually 10%. We found the following in the maint plan...more >>

Hi: I'm using SQL2005 Developer edittion, I need to change the server collation from Chinese_PRC_CI_AS to SQL_Latin1_General_CP1_CI_AS using setup.exe start /wait setup.exe /qn INSTANCENAME=WIN2K3ENT-CS\SQL2005CS REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> SQLCOLLATION...more >>

I'm having a fatal exception using the tcp/ip protocol. If i enable the tcp/ip protocol using the SQL Server Server Network utility, an i try to resart the server to enable tcp/ip. The sql server aborts startup (fatal exception c0000005) If i restart the server the sql server starts, even if...more >>

I intend to run SQL 2k on a dual processor server, my company wish however to be very economic with licenses and i'd like to know if you run SQL 2k or 2005 for that matter, is it possible from inside SQL to set the application to only run on one of the processors? I know this is a bit of a ...more >>

Is it possible to run both versions of SQL on the same box. ...more >>

Hi, i'm looking at installing SQL on a blade or a virtual server, but alas the storage on either will be limited, so my question is can i put the transaction log onto a san across a mapped drive? Will there be any performance issues or back up issues by doing so? ...more >>

Dear All, Is it possible for me to have a SQL profiler install in my local while i = have running SQL Express in my machine? Please advise, thank you....more >>