I am trying to copy two columns (OC_ID_ & OC_NAME) in one table (ORG_CHARGE) in a SQL SRV 05 DB (VFM) into two columns (DEPT_NUM and DEPT) in another table (DEPT) in another SQL SRV 05 DB (TRACK IT). I have to accomplish the following with the data: * Update if the record exists * Ad...more >>

Hi All, I have a database with about 250 stored procedures. I need to give some users execute permissions on all of these procedures. Can anyone tell me if there is an easy way to select a group and grant execute permissions to it for all 250? I basically need the group to be able to exe...more >>

I have a table with users. These users are joined to an address table by an intermediary table called user_address, which maps the addressids to the userids. A user can have multiple addresses, denoted in the Address table by an int identifying the type of address. Here's my issue... I ne...more >>

Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job first. Now I can not delete the job. Is there any way I can delete the job? Thanks in advance for any help! ...more >>

Hi all I have managed to setup the entire environment and get some C# CF code to sync to the Database and use filters. I could not have done it with out the help of these news groups. So thanks to all. I now have a few more question regarding different topics to do with sync...more >>

Trying to read a sql server 2005 table from a vendor and I'm not having any luck I'm getting the error : Invalid Object Name '_SMDBA_._CUSTOMER_' on execution of the select statement I'm not real skilled when it comes to attaching to sql. I have the sa as the authorizing account so I ca...more >>

Is there a way to setup an automatic function to backup the databases in SQL 2005 Express?...more >>

I have an application that we created in Delphi. We're using SQL 2k (fully up to date). All this is on peer to peer network with win xp pro machines. The machine the sql server is on is used as a workstation. The app is using ADO to tie into the sql server. The app runs fine for hours at a tim...more >>

I have a bit of a strange problem, I'll attempt to describe it as best I can. Any directions to other resources would be appreciated. This is on SQL server 2000, with SP4 running on windows server 2003. Sunday, the 25th, at 3:00am, the server installed the timezone patch (kb931836). at...more >>

can you please give me an idea about the advantages/disadvantages between using numeric identity versus uniquidentifier in sql 2005 and which is a better choice generally? Is there an article on MSDN in a table format that lists the differences plus recommandations on when to use each one of ...more >>

Hi Folks, I have sql express in my laptop because visual studio installed for me. Now I wan to install sql developer edition. Should I upgrade sql express? How? or should I uninstall express and install developer? I want to have only developer version on my laptop, but also I'm wondering if ...more >>

Hello! Is there a way to view which primary keys are clustered and which ones are not for all of the tables in my database? I know there is sp_helpconstraint...but I can only use this to view one table at a time. Any suggestions?? Thanks!!! Theresa...more >>

Hi all hope this is in the right forum. Ive got a SQL database which accumulates about 4 million records each year. This amount causes my PC to slow down when searching, and my hard drive is getting fuller. To overcome this problem I have to delete half the records each year (2 million...more >>

Hi, I sit possible to have a FK constraint between 2 tables in 2 different databases on 2 different databases Thanks in advance...more >>

When I run the following DBCC command to reindex all indexes (in most cases only one: clustered) on a table... DBCC DBREINDEX (<table_name>, '', 10) It reports the following error: Could not allocate space for object ... in database ... because the 'PRIMARY' filegroup is full. This i...more >>

I'm attempted to run an installation of SQL Express 2005 from the command prompt. I've downloaded the redistributable SQLEXPR32.EXE and now want to get my hands on setup.exe, template.ini, etc.. that I will run from the command prompt. I can see them being created in a temporary folder when I ...more >>

hi, i know how to check what version of service pack i have installed on sql server 2000...but does anyone know how to find out the date it was installed on. i am having probs with sql server agent and can see the date the probs started...and think it was about the time sp4 was installed bu...more >>

Is it possible to have SQL 2000 standard and SQL 2005 enterprise running on the same machine? ...more >>

Hi all, I am having one stored procedure which is returing parameter having text data type. This paramter has to take value from table which have column with datatype as text. How will i set value to parameter having text datatype to value present in table? Any help will be truely app...more >>

I have a database which constantly saying it i starting up!!!! 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'. 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'. 2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'. 2007-02-28 12:35:41.09 spid63 Sta...more >>

Hi, I'm trying to figure out if doing an INSERT INTO.. a table with indexes is faster (or slower) than doing a SELECT INTO and then creating the indexes on the table created. The table in question contains around a million records. Thanks *** Sent via Developersdex http://www.develope...more >>

Hi, I am using 2 servers with SQL Server 2005 installed on them. I have 1 Database (say the Corporate Database) on Server A and the other databases (say the Department Database) on Server B. All the core tables that are shared across all the departments are stored in the Corporate Database (s...more >>

Hi what is faster - LEFT JOIN or subselect example SELECT T.TITLE,S.ID FROM TITLES T LEFT JOIN SINDEXES S ON T.ID=S.TITLE_ID or SELECT T.TITLE,(SELECT ID FROM SINDEXES WHERE T.ID=TITLE_ID) Mex ...more >>

No, this is not another question about why my log file is so large. I have a client whose log file is 2.8 GB. This is not a problem. Database is in full recovery. We take transaction log backups every 20 minutes, and a full backup once a day. However, the problem is that DBCC SQLPERF(LO...more >>

Hi, I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL server. My ASP.NET program can be access the server, but I found that I cannot login the SQL server using Microsoft SQL Server Management Studio. I checked the ERRORLOG on my server, which shows...more >>

Dear all, I have to migrate an SQL Server 2000 to a new machine because the old one experiences some hardware problems. There will be no changes in the configuration during the migration - the new system should be exactly the same as the old one (including the name / IP address of the machi...more >>

I have a server/client application that has multiple users with different access rights to the data in a database. Access is granted on a column level. First I was planning on writing my own autorization/ authentication layer. Then I was told that the right way to do this is by creating views th...more >>

What does autoclose do ? And why Starting up database message is repeated when autoclose is true? ...more >>

I am working with SQL 2005 64 bit sp1 , i am facing problem continues in error log file mentioned below, can you please help me SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] ...more >>

SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it cannot use more than 3GB RAM under any circumstances, but it can be installed on a server having more than 3GB total RAM; or, does that mean that it cannot be installed or used on a server having more than 3GB RAM?...more >>

Is there a way to shrink the log file below it's Initial Size? Somehow the initial size for a log file was accidentally set to 25 Gig. This extra large log file is keeping the backups from working (no disk space). I've tried Shrinking the log file, but I'm not allowed to shrink it below it...more >>

I'm having trouble making a remote connection to a SQL Server Express database. The service is started, and the connection works locally. I tested it using a .udl. In this local .udl, I use the SQL Native Client as the provider, and a Data Source entry of (local)\SQLEXPRESS, with username/passwo...more >>

I'm running XP SP2 (and all the latest hotfixes) and administer a bunch of SQL2000 servers. Whenever I have enterprise manager running, I find that my network access seems to block regularly. What I mean by that is, If I open Explorer and try to access network drives, explorer will hang for 10-1...more >>

So, I've seen references to using the transfer logins task, I have gone thru the Copy Database Wizard, but I can't seem to figure out how to actually copy the logins over. I'm sure it is something simple that I am just overlooking, but if anybody out there would give me a hand, I would greatly...more >>

Environment: SQL Server 2005 Enterprise Edition SP2 Windows 2003 R2 x64 Enterprise 80+ Databases, all upgraded to compatibility 90 Since upgrading to SP2 for SQL Server 2005, my scheduled jobs based on Maintenance Plans which include Statistics Updates, Index Rebuilding and Inde...more >>

Hi all, I have (had) a development machine with sql svr 2k running, it was only used to test the software we developed. Well, the sql server machine died, it still boots and the drives are accessabe. but sql server won't start (as won't many other services, like rpc) so I can't get to the d...more >>

Hello: In continuing with a posting that I made yesterday here on the Newsgroups, I have today reviewed the SQL Error Log for a database maintenance plan that I have that backups my databases to an external hard drive. The backup to this external hard drive is failing for all of the databa...more >>

Is it possible to access an SQL Server 2003 Database using SQL Server Management Studio Express in the same way that I would use Enterprise Manager for SQL Server 2003? Considering upgrading to SQL Server 2005 and want to start testing with SQL Server 2005 Express but don't want to have to swi...more >>

Hello, We have a production database which is in SQL Server 2005. All the stored procedures and Views created in 2005 ( 90 ) compatibility. Some Stored Procedures and Views started failing one day. We found that the database has compatibility level is on 80, but It should be 90. Aft...more >>

Hi! I am looking into a way to put Windows Logs into SQL Server database and to be able to query them for specific information. Anybody know the tool that I can use and be able to schedule it to run on a weekly basis? Thank you, T. ...more >>

All Is there any way to estimate how long it would take to drop and rebuild the indexes on a database. I have a farily tight maintenance window on a payroll database and need to be sure that any work would be completed in time. I assume the database size and amount of tables has a major bea...more >>

I get the following message in the SQL Server errorlog "Migrating page intent locks from .....". This is sometimes followed by "-- Migrating key resource: KEY: ......". I'm not certain what process triggers this message. Help....more >>

Before SP2 my maintenance plan was stable. Now, I get the following when I try to modify the plan: Microsoft SQL Server Management Studio is unable to load this document: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the follow...more >>

i am having a heck of a time -- i know SP2 makes sql server 2005 incompatiable... however, i need an instance INSTALLED first and that is where the problem lies. i of course built my system and put office on before visual studio - so office put sql express on the system (which worked by the w...more >>

I have a setup where in following scenario i get DCOM error 1. Install a 32 bit NT service on x64 2. Install SQL 2005 Server 3. Upgrade the 32bit NT service using msi package. After step 2 the NT service is running fine. But after step 3, Service fails to start with Error, The MyService ser...more >>

I have 180+ databases on a production SQL Server 2000 system that I would like to copy over to a new SQL Server 2005 system for testing prior to rolling out a new database server. Unfortunately, the Copy Database wizard using SQL MO fails. The event log shows that it could not create a view...more >>

Hi everybody, I have the below script on SQL Server 2005, SP1 on Windows 2003 Server to backup a database BACKUP DATABASE [XYZ] FILEGROUP = N'PRIMARY' TO [XYZ] WITH NOFORMAT, NOINIT, NAME = N'XYZ-Full Filegroup Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO declare @backupSetId as in...more >>

Hi All, I'm using the SQL Server 2005 tuning wizard and its come back with a few suggestions. If I implement the suggestions it estimates a -1328% improvement. Now does this mean things will be -1328% "better" or -1328% worse -1328% doesn't sound much like something I'd want, but then w...more >>

Hi I have problems with query timeout. Funny is, from my computer i can't re-produce this timeout error. Clients with slower internet connections get this error often(application is client-server based) First i used select top, to reduce results, but this does not help. Indexexes are ok. ...more >>

somewhat lacking in DTS wizard in 2005 Standard Management Studio ? were did it go : ( scott ...more >>