dear all, I want to execute this statment Select db1.dbo.table1.column1, db2.dbo.table2.column2 from db1.table1 inner join db2.table2 on db1.dbo.table1.column1= db2.dbo.table2.column1 since i am using to different DBs to fetch resultset. What should I do to accomplish this task. One way i...more >>

Hi all, I am building a new IBM xSeries 345 server and we plan consolidate most of the SQL Servers databases on it (~40). I am trying to figure out the best configuration for the disk subsystem for both reasonable performance and disk cost savings and reduced down time. The server may have u...more >>

Got a call for a job working on (current?) Sybase system, they seem willing to accept SQLServer expertise. Anybody have any words of wisdom on the differences in the current products? (as I understand it, the other tiers are dotnet! Let me guess the legacy clients are Powerbuilder) TIA....more >>

Hi, Hope someone can help. If I click on SQL Server Licensing in Control Panel I get 'error locating sqlsui.dll' I Googled for a solution and the only reference was if this file was missing or corrupt in program files\microsoft sql server\80\tools\binn but the file does exist. I tried repl...more >>

Hello, I have 8 categories, each with its own (Min, Max) limits : - Cat_1 (100, 199) Cat_2 (200, 299) Cat_3 (300, 399) .. . . Cat_8 (800, 899) On the screen, when a user clicks on a link, say, Cat_2, they see a summary of all the issues under that category. When they insert an issue...more >>

I am trying to delete a database because I need to restore it. But when I try deleting I get an error message stating "Error 3072: Cannot drop database because it is currently in use." I closed query analyzer and browser windows using this database. I cannot figure out what is still open. ...more >>

We are planning to put our tables on one filegroup and the indexes on the other. In SQL 2005, it is possible to restore just 1 filegroup and continue operations. This sounds fine if the tables and the associated indexes are on the same filegroup. But what happens in my case ? If the index file...more >>

Hi , We are getting 17833 error with below message . Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on Scheduler 3. We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4 but I still see this in SQL log at least once a week . Can you pl. sugg...more >>

I know it's possible to view AD data via a linked server & using LDAP queries from SQL. But I'm wondering is it possible to update the data in AD? More specifically - I've got a sql server database table of user information (userid, password, etc.) - when the user modifies their password in th...more >>

I can not bulk insert a network file onto a remote SQL server 2005 machine I get this error when run from Query analyser in remote machine Cannot bulk load because the file <File Name> could not be opened. Operating system error code 5(Access is denied.) It used to work in SQL 2000 We just ...more >>

I have a database with with four filegroups - the primary and three others. Each filegroup has its own data file. However, one of the filegroups has two data files. I want to restore the database to a different database server but only the primary filegroup and one additional filegroup inst...more >>

I have a database that has Korean_Wansung_CI_AS as the default collation. I need to use this database to interact with another database (e.g. merge tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The first step is to change the default collation of the first databse from ...more >>

Hi all, I have a sp where I only do an insert, and am trying to return the identity value created. Here's what my sp resemble : .... AS SET NOCOUNT ON -- do the insert DECLARE @ret SELECT @ret = SCOPE_IDENTITY() RETURN @ret I tried to return directly SCOPE_IDENTITY(), I also tried to...more >>

I've got about four production 2000 servers still on SP2. We've done some preliminary testing with SP4 on our dev environment and SP4 seems to be having no problems. But I've read a number of posts about problems with SP4. Is SP4 having some problems like the ill-fated SP3? Is there going ...more >>

Does anybody know of a way to move maintenance plans from one Yukon server to another? I don't want to have to manually set them up on each server. I'd like to be able to script it, like in SQL 2000, if possible. Thanks in advance! ~ Lindsey...more >>

Does anybody have some testing down with the Pro's & Con's of using a SAN for the dB, Index and Log files? Thanks Gary ...more >>

When I go to Process Info in SQL Enterprise Manager, sometimes I can see the same sp_id in there multiple times (5-10 different instances sometimes). And sometimes the same sp_id is listed as blocking itself!? It is the first time I am seeing this. It used to be that there was one entry per s...more >>

I'm looking for different solution people have implemented to solve this problem. Problem: People need to work remotely. While working remotely they want to gather information. This information might be survey info, or inspection info, etc. This information is to be stored remotely on a ...more >>

Hello, Following is my understanding when sql needs anythings reads from disk it request to Windows which do 64 k read even though sqlserver has only requested single record?? Am I right? how sql handle the I/O request when it reads from RAM (data cache)? Thanks. -- Farhan ...more >>

Has anyone tried running SQL2k x86 on a Win 2003 x64 platform? Any issues? Also, is there any benefit of running SQL in a x64 environment even though it's only 32-bit? LC...more >>

hi everyone, I have a question regarding the upgrade process from build 922 to build 1007. I understand that builds 977 and 1007 are 'baseline' builds, but there's a known bug with applying build 977 on servers with a large number of databases (KB 891640). Because of this bug, should I just...more >>

I have two servers 2003, one running sqlserver 2005 and the second sqlserver 2000. I'd like to register the sql2000 on the sqlserver management studio provides with sql2005. when I trie to connect to server with sql2000 I get an time out error. I've already activated all the protocol : tcp...more >>

I want to copy data from one sql server table to another sql server table. In the original table almost all columns are of data type = 'varchar' , in the destination table, I would like to convert columns into various data types like 'nvarchar', 'numeric', date, etc. When I try to issue the ...more >>

Do code coverage tools exist for SQL. I am not talking about really complicated one. Just perhaps a tool that will scan a stored proc, then mark/remove unused variables, for instance. Regards...more >>

hi to all , Is it posible to backup a sql 2005 db and restore it to an sql 2000 database , I have succesfully done the reverse of it ,that is bakup an sql 2000 db and restore it to 2005 but could not manage to the reverse of it any help will be appreciated regards... orcun ...more >>

Hello Everyone, Our company is currently under the Enterprise agreement with Microsoft and I was wondering when it came to clustering, how many processors do we have to licenses if both boxes has four processors in each box? The way we're running the cluster is Active/Passive. We are ...more >>

Hi, we moved all database instance (included sysdb) from a disk to another. When we try to start the instance in single mode all should be ok. When we start the instance in normally mode we find the follow error message in the errorlog file 'Error while redoing logged operation in database 't...more >>

I have log shipping set up on some databases, but I've never used the assume primary role option and I have some questions about how it works. What does assuming primary role do? Can something automatic trigger the event or does it require manual intervention? If it's automatic, what kind of ...more >>

How can I determine if the sql instance I have is the default instance or a named instance? Secondly how do I adjust a named instance to be the default instance? Lastly if I have 2 servers configured identically (one working as a production server and the other as a backup server) and a pr...more >>

Hi all, if I create a new schema: CREATE SCHEMA MySchema it appears in Sql Server Management Studio's schema, but it's not obvious to me how to create a new table (or other object) under this schema, without using the CREATE TABLE statement. How can I create a new table under this schema u...more >>

I will be doing development work and testing on Sql Server 2005 and Sql Server 2005 Express. What is the best installation for my requirement? Is it possible to install both on the same machine? Thanks, Marc...more >>

Does the SQL Server 2000 Standard Edition fully support the /3GB switch on Windows 2000 Advanced Server Editon?...more >>

I run the below code on several servers via a scheduled jobs, on one server the job fails reporting "Error converting data type char to datetime. [SQLSTATE 42000] (Error 8114)", Any ideas on where to start troubleshooting this server, I can't think? DECLARE @BAKDate Char(10) SET @BAKDate...more >>

We get ripped off in the UK and so US licences cost around half the price. My question is can UK businesses buy licences in the US or join the US open licensing? I'm sure Microsoft wouldn't want people to do this, but if you got hold of the licences would it actually work? Also, what if your ...more >>

Hi All, I noticed that SQL 2000 seems to be eating up a bit more memory (about 100Mb more) than the maximum memory that I have set. Is this a normal behavior? Thanks. Aramid...more >>

hi all, maybe a poor question, but i cannot test it for myself now. when i shutdown or stop sql server, will there all logfiles be written in the databasefiles, the same as a backup will do? thanks for help jeff ...more >>

Hi, Any one know about Linked server setup in sql server. I want to know more detail on setting up a sqlserver to connect it directly to an oracle server. So that I can directly access data's from Oracle using Stored procedure. Regards, Sasikumar Balasubramanian ...more >>

Hi, Any one know about Linked server setup in sql server. I want to know more detail on setting up a sqlserver to connect it directly to an oracle server. So that I can directly access data's from Oracle using Stored procedure. Regards, Sasikumar Balasubramanian ...more >>

Hi all! I am about to create a procedure which will create tables with dynamically specified tablenames. Something like this DECLARE tname CHAR(30); SET tname = "1233321"; #or any string function CREATE TABLE tname ( #columns cpecification ); But it doesn't works.......more >>

Hello, How do I hide databases that I don't need to see on a server? I am using SQL Server Management Studio 2005. Thanks! -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Best free software http://www.vbmark.com Freeware-dedicated search engine http://www.eurekster.com/par...more >>

My devs all have access to production. They always had and they feel they should still just in case they need to resolve issues. Are there any articles on how I can convince them to get out and stay out :) Let me know what should i tell them so I can revoke their access Thanks ...more >>

Im really confused about cursor stuff that isnt quite explained in the BOL. What exactly is the difference between a Tsql cursor and an API cursor? When I access a db from a .NET application is this an API cursor? is an API cursor the same as a server cursor? does an API cursor/ server cursor hol...more >>

Hi, I have created the following SP and indexes, but the execution plan for SP shows that query optimizer always uses 'index scan'. -------- use northwind go create proc usp_search @country varchar(100)=null, @city varchar(100)=null as select customerid,companyname,country,city from cus...more >>

I set up a linked server and attempt the following command: exec serverX.dbX.dbo.procX I get this message: Server 'serverX' is not configured for RPC. This used to work in the beta version of 2005. Running a select still works: select * from serverX.dbX.dbo.tableX The help file is w...more >>

I have a 2005 database with Auto Create Statistics set to true and Auto Update Statistics set to true. Am I correct that it should not be necessary for me to manually execute any 'Create Statistics' statements to create statistics to help in query plan generation? My assumption is that with ...more >>

Hello! We are planing to release one bigger project.... And buying larger, better and faster sql-server to it. How Big server do we need? What licenses? We need it to build fast enough reports from 10-40 000 000 row tables. Mainly use quite big tables and grouping it. We have coulple of t...more >>

I have a user in DB that has db_datareader and db_datawriter permissions. Now I want to assign EXEC permission to all the stored procedures. How can I achieve this through database standard roles. My objective is to avoid giving permission on each stored procedure the EXEC permission. Any ...more >>

I am trying to rewrite 2 stored procs that have been perpetually having deadlock issues against each other. The current problem is that the pieces of SQL that are involved in the deadlock are both in a transaction. The contention is for a single table. Would moving the offending piece of ...more >>

I have database. The database is pure OLTP database. Performnace is very important for the database. 90% of all db calls is call of 4 stored procedures. I created test script which do such calls. I do performance tests both in SQL2k and in SQL2k5. Databases have exactly same data. I did update...more >>

Our database is on a server provided by the web host. I would like to backup the data from this database more often than our web host performs backups. But since our database shares space on its server with other companies, we are not permitted to use the Enterprise Manager Backup utility. (T...more >>