I have never done replication before, so treat me like a novice, even though I'm otherwise familiar with SQL Server. I have a database on a SQL 2000 machine. Soon, I want to port the database to SQL 2005, but in the meantime, I want to do some testing against our new 2005 box. I thought I ...more >>

I see values of 2:3:22 for waitresource Can someone tell me what those values represent ? ...more >>

Hi; I asked this once before but can't find the info now. I need to copy a database from one server and put it on a second server. It is Sql Server 2000 and both servers are running Windows 2003 in a workgroup (not a domain). I want to get all of the data and meta-data across. How can I do...more >>

Hi just wondering if mssql 2005 integrates ok with vs2003, thanks. -- Paul G Software engineer....more >>

i have a database that's about 1.8GB and would like to back it up. I just found out about it, but am reluctant to backup it up with the software GUI part since it's my only database. Will it work if I copied the Data File (.mdf) and the Transaction Log (.ldf) to another disk manually to be...more >>

Hi just wondering if anyone knows if it is possible to run a .net application with a dts package, thanks. -- Paul G Software engineer....more >>

There are many articles about SQL customers who experienced degraded performance after applying SP4 on SQL2000. Has anyone seen the same behavior on 64bit edition of SQL2000 after applying SP4-ia64 on SQL2000-ia64? Tom. ...more >>

Hello Everyone I am getting the following error when i try to insert a record into Sql Server 2005 from my VB 2005 application. sqlEx = {"Error converting data type numeric to numeric."} I checked for possible overflow exception, but did not encounter any. I have declared the values that ...more >>

Setup: SQL Server 2000 Standard I have a column that contains passwords that are made up of a mix of uppercase and lowercase letters and numbers. They're supposed to be case sensitive, but aren't. How can I change the column settings so that they are case sensitive? Thanks in advance. ...more >>

I have a server that is running SQL Server and a laptop that is running it as well. They both start the day with the same database, but both have changes throughout the day to them. At the end of the day, I want to be able to move the new data from the server to the laptop and vise versa. A...more >>

I've had a problem with my secondary server where I suspect that a log file may have been corrupted in-transit and what to re-send again via the logshipcopy jobs. I took last nights backup and restored to the secondary and now just want to "catch-Up" the trans logs to get current. What is ...more >>

We're currently running SQL 2005 Std. Ed. and utilizing the Service Broker functionality. I've noticed complaints from our system monitor about lock waits exceeding 35/min. All of the common hardware perfmon counters (memory, disk, CPU, network) are very low so it makes wonder what's going o...more >>

I am attempting to tighten the security of our MSSQL environment in a number of ways and one of these is to run scheduled CmdExec jobs via a non-admin Windows account. Alas, I cannot get this to work correctly. I created a credential "abc_job" based on a non-admin Windows domain account "d...more >>

I need to move all our security information from our old server to a new server. What is the best way to do this? We are using SQL2000 SP2 ...more >>

As an SA, I can create DDL triggers on some of our more important databases. However, how do I prevent the dbo's in the database from deleting or disabling these triggers? ...more >>

Hi, I've developped a database driven application using Visual Studio and the SQLEXPRESS that comes with it. Since I haven't used any features specific to SQL 2005 I wasn't really concerned about the migration to SQL2000 which is the only production server that we have in the place I work. ...more >>

Sir, It is urget pleasse: I have two Database Server. Similer OS Configuration Both are Linked Servers in one Domain Network DTC is also enabled. MSDTC configuration is also done. I have written nested trigger, which insert,updates,deletes across both server. but it gives folling error...more >>

Hi Friends, Could you tell me how to add text in a select statement. For eg: SELECT ((datepart(MM,CURRENT_TIMESTAMP)+ '-' +(datepart(dd,CURRENT_TIMESTAMP) + '-' + datepart(yyyy,CURRENT_TIMESTAMP))AS "CURRENT_DATE" ..................ofcourse,this is not correct but it reflects my idea. Thanks...more >>

Hi everyone, I'm a british developer and so my SQL Server is on a british computer. The problem I'm having is that dates are being stored in the British format and I desperately need them to be stored in the American format. The applications I'm making are all for the American market and ...more >>

I would like to setup/create a DB maintennace plan in SQL 2005 as follows: a) Backup Database (Every Night) b) Backup Transaction Log (Every Hrs) As you all know the above was easily accomplished by specifying the Database backup schedule and then Transaction Log schedule. So far I am NOT a...more >>

Where can I find about differences between two edition. I need to advise this for a customer who would be quering over the WAN...more >>

Hi friends, Does anybody could say how to remove the TimeStamp from DateTime part in TSQL. Thanks&Regards Sunil. ...more >>

Hi friends, Does anybody could say how to remove the TimeStamp from DateTime part in TSQL. Thanks&Regards Sunil. ...more >>

When Looking through my SQL Profiler Log trying to work out why the CPU usage maxes out the CPU to 100% for long periods, Ive noticed entries Audit Login & Audit Logouts with high durations eg 306130 is this normal ? If it isn't what can I look at in reducing this figure TIA...more >>

I know this is a very open ended question, but it is one that I have not yet found an answer to. How powerful is sql server? I appreciate that there are ways of making it more efficient, but surely there are limits. For example: how many records can it handle in a database before it just b...more >>

In order to find SQL Servers 2000, in my .NET application, I successfully use "SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find instances of SQL Servers 2005. Is there anything else available to do this job? Thanks for any hint. Axel Hecker ...more >>

Hello, Sorry (again) for a very ignorant question, but is it possible to search an entire DB for a string? Also, is it possible to find out where a sp is located? I have a DB with an SP that will execute, but I can't find it anywhere (in Enterprise Manager) to look at the code... Any id...more >>

Hi! Anybody Please help me, i want to find out the Query for most recently used Database tables and stored Procedures i.e from last 6 months. As bcas of there are lots of Procedures and tables which r unnessary due to this my site is getting slow. So if i find the Query so that i can start ...more >>

I do schadule Complete backup to my database every 3 hours, But my backup file become to big (74Gb) because it's append backup in one file and there is no way to delete old backup from it so i have to start a complete backup again and delete the old one every 2 days.. That wasn't a good idea,...more >>

Hi All, Here is the table called "item", id is the autoincremented primary key. id | barcode | status ------------------------------------------------------ 1 | abc | 1 2 | abc | 5 3 ...more >>

Hello All, In SQL Server 2000, I have created a new user and given it public access to only one database, but when the user logins to the database server he can see the names of all databases on the server, although he cannot do anything to them, is there a way that the user can only view...more >>

Hi, I am analyzing a query. I have set the SHOWPLAN_ALL option to ON. Does anybody know what are all the possible values that can appear in the "Type" column for both SQL 2000 and SQL 2005. Thanks, Prasad ...more >>

TITLE: Microsoft SQL Server Management Studio Exception has been thrown by the target of an invocation. (mscorlib) ADDITIONAL INFORMATION: An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed. An OLE DB er...more >>