Keep in mind this is my first compiled SQL program Stored Procedure (SP), copied from a book by Frasier Visual C++.NET in Visual Studio 2005 (Chap12). So far, so theory, except for one bug (feature?) below. At some point I'm sure I'll be able to laugh about this, akin to forgeting a semi-colon...more >>

Hi, I'd like to do a daily backup of my db using windows programmed task and running the following batch file: sqlcmd -S server\db_Express -U username -P password BACKUP DATABASE [dbSQL] TO DISK = N'D:\db05\dbSQL' WITH NOFORMAT, INIT, NAME = N'dbSQL-Complite backup', SKIP, NOREWIND, NOUNLO...more >>

i am about to create a database diagram but this error appears. what does this mean and what should i do? tnx This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Ensure the dbo account is valid and e...more >>

I have a foreign key. I want to script how to create it without using the management studio i.e. from the query analyser in SQL 2005. Is there a system stored procedure or something that does this for you. thanks for your help Newish ...more >>

Hi, I've just setup SQL Express 2005 SP2 on my fresh SBS 2003 R2 system. I never had anything to do with and have no idea about SQL, the only reason for updating from MSDE was the annoying and ugly event id 1000 relating to sharepoint services in my application log. There seems to be no wor...more >>

Just want to clarify the date from which a DB backup with DIFFERENTIAL option includes its changes. I have a db which I do a full backup on Saturday, and a differential the other days (this is plenty in our case) If someone performs an ad-hoc backup for whatever reason during the week, s...more >>

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice comparison between an up-to-date version and an older version of the same database. However, when I try to synchronize, it synchronizes the normal tables, then I get a message: The following error message was returned from...more >>

Hi All I have a table that contains a comma separated list of products that I want to pivot so that they each product is listed individually. Below is a sample of the table and the data as well as how I am trying to return the data. Any assistance anyone can provide would be appreciated. ...more >>

Hi, I have a table with 15 columns. However, in my data file I only have 9 columns. I have created a format file to map the data fields to the relevant columns. Each time I BCP data into the table though it just inserts the data into the first 9 columns regardless of the fact that I have mapp...more >>

Hi Folks! I have just installed SQL Server 2005 (Standard) on my work (networked) computer and I'd like to create a "sandbox" database on my computer to play around with. I have admin rights on the computer. I should point out I know NOTHING about sql server 2005 right now. I'm pretty good ...more >>

I have a windows server 2003 sp1 server that had SQL 2000 SP4 installed and I was able to back the databases up using CA's brightstore with no problems. Due to hardware contraints we installed another instance of SQL 2005 on the same machine and now I am unable to backup the SQL 2000 database...more >>

The problem seems to be with the authentication. It froze when Windows updates attempted to install it, so I downloaded the exe from the ms site. However this freezes too while running the "Authentication Verification". This also happens if I just click the Test button. I tried both Windows Auth...more >>

We have a web app currently being hosted on a RAID 5 with four disks, 2 GB RAM, Xenon 3.2 processor. Also running Windows 2003 Server Standard Ed. and SQL Server 2000 Standard Edition. Our database is about 4GB and at most we have 10 concurrent users hitting our server, with a mix of read an...more >>

Hello Hopefully someone is knowledgeable about this that can help me. We use SQL Server, and usually FTP our microsoft documents up to it. Obviously, when different locations access these files through our intranet, they are read only. I wanted to see if there is a way to make one particula...more >>

Hi! Two questions, one simple and one a bit harder. First, the licencing model. How does per processor licencing work if you have a dual core processor? Is it per physical processor or per core? Secondly, If I run a database in 80 compatibility mode in a sql2005 standrad, will I be und...more >>

I've read that when using DBCC shrinkfile or shrinkdatabase it is best to be in single user mode. My question is when using DBCC SHRINKFILE on the tempdb (tempdev) while the database is in production and live is this bad? If I use the sys.database_files view to figure out the unused space and ...more >>

Does SQL Server 2000 SP4 enable the Standard Edition to run in native x64-bit mode or is it just the Enterprise Edition? We want to consolidate our three, separate 32-bit servers for SQL Server 7, SQL Server 2000, and SQL Server 2005 (all Standard Editions) to all run on a single, beefed up...more >>

I encountered a nasty bug in SQL Server 2000. Symptoms: When you try to create a query in the Query Builder of Enterprise Manager, the selected tables are displayed without columns. Only * (All Columns) is displayed. Besides that, the table receives an alias with <table name>_1. You can creat...more >>

I am setting up a new SQL Server 2005 EE server with Reprting Services installed. The log files have all been moved to a seperate drive. However, I have never moved log files for Reporting Services and can find no documentation for this procedure. Is there anything unique about moving the Re...more >>

Hi, Greetings... I'm given 'SYSADMIN FIXED SERVER ROLE' for a database. But, I'm unable to run DBCC FREEPROCACHE DBCC DROPCLEANBUFFERS statements. Could anybody guess what could be the reason. As I'm dumped with many tasks today, I seek ur help. Thanks Dutt. ...more >>

Hi All, We are trying to restore a database from a live system to our test system. However, we are receiving the following errors when attempting to perform this restore "Modify file encountered operating system error 112(error code not found) while attempting to expand the physical file...more >>

Hi I have a very simple local package, which performs the following: 1. Execute SQL Task Delete from PURCHASE_LEDGER Delete from SALES_LEDGER 2. Transform Data task Copy everything from SAGE PURCHASE_LEDGER to SQL PURCHASE_LEDGER Copy everything from SAGE SALES_LEDGER to SQL...more >>

Hi I have setup some log shipping scripts to create a warm standby server at a DR site. Essentially, I run a job which runs a backup to a remote mapped drive, then runs a stored procedure to restore on the remote server using a linked server definition on the local server. There are correspon...more >>

Hi What is the maximum amount of RAM supported by SQL Server 2000 on Windows 2003 standard edition server? Regards Ram ...more >>

Hi, I'm starting to build a database that will contain English and Welsh text. Up until now I have just used the default collation settings, and everything has been fine - but I've only ever needed to use English. There is also the possibility that, at some point in the future, the database...more >>

Hello, SQL Server 2005 EE Trial Version SP2 Win 2003 SP2 I've tried to backup the AdventureWorks database with the help of Maintenance Assistant, I've created a fairly simple job, straight forward, no tricks and radio button clicks! I've started that job and after a while I got an error i...more >>

Is there a way to open a webpage through SQL? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1 ...more >>

Hi, Is there an esay way to gather information about how many times each stored procedures has been called , the average execution time , etc .. I know profiling can give you punctual info about this .. however i need aggregated info over a determined period of time thank in advance best rega...more >>

I've written a frunction that accepts 2 nvarchar parameters, which are passed to 2 IN clauses of the where portion of a SELECT... such that the function can be called like... select * from dbo.fn_GetDTZInvoice(N'SINV146917', N'SCRN010040') This is working fine, however, I want to be able to...more >>

Hello, SQL Server 2005 EE Trial Version SP2 Win 2003 SP2 I've tried to backup the AdventureWorks database with the help of Maintenance Assistant, I've created a fairly simple job, straight forward, no tricks and radio button clicks! I've started that job and after a while I got an error...more >>

I have a client experiencing problems with SQL Server 2005 64 bit (sp1). The server has 4 gigs of memory available, however I can not increase the memory allocated via management studio past 2 gigs. When I look at the .exe in task manager, I see that service is using about 3.5 gigs. Can I jus...more >>

Good afternoon! I know that I have asked this question a while back but I can not find it so I am asking again! This time I will print it out! First off, I am not a database guy! At all! This is something that will change in the future, though. A client has a single WIN2000 SP4 syste...more >>

At one seemingly inoccuous step in my CLR stored procedure, execution stops and the query times-out. I've tried debugging the stored proc by stepping into it from within VS. When I do, I get to the code in question, but then simply get this message: WARNING: Debugger was accessing T-SQL ...more >>

I am trying to create a centralized job monitoring system that can be managed by some operators to restart a job if it fails. Everything will be running on one system but I need to invoke remote jobs on remote system. I am having trouble starting a job on a remote system even if I have the perm...more >>

Hi, I was trying to test SQL Server 2000 master database restore and to do that I stopped MSSQLSERVER service and tried to restart with a single user mode. However, on typing the command "sqlservr.exe -m" in the Command window it stops at the point where it says "Using 'xplog70.dll' version...more >>

I have a 2000 db that I've restored to a 2005 machine. When it restored it restored as a version 80 db (2000 I would assume). To convert it to 2005 do I just go into options and change the compatibility to 90? Will it tell me if there are things that can't be converted? TIA - Jeff. ...more >>

Hi. I am in the process of "ramping-up" (read: spending more money) on a home project. To date, I have done the web and database development on the same machine. I have been advised to put the DB stuff on its own box. My question is, what kind of box should this be? What are the essentials wh...more >>

Using the SQL Server 2005 Maintenance Wizard -- Where do you tell it to delete files older than a certain date? With SQL Server 2000 it is a checkbox where you specify an age before it is deleted. Any suggestions appreciated! RBollinger ...more >>

Hi, Is there a Visual Studio Add-In for the new equivalent of DTS that can used with SQL Server Express? Thanks, Gabe ...more >>

Hi, We have a MSDE 2000 installed on a Blackberry server that contains Blackberry configuration data. For testing the Net backups we need to restore it to a SQL Server 2000 server. The SQL Server 2000 is already installed and has couple of test databases that I will drop before doing the re...more >>

SQL Server 2000 SP4 Trying to backup to a network resource when SQL uses the machine service account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name', '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't work because of permissions. Fairly new t...more >>

Have 2 stored procedures; procA and procB ProcB calls procA within it. ProcA has select queries that pulls data from a linked server and then returns a select statement. Within ProcB when I execute the procA, I insert it into a temp table. Cause, for each record that is returned by procA,...more >>

All I've been given is a bak file and I need to get the *.MDF and *_log.LDF files from it. Any ideas? ...more >>

Hello, I keep getting these errors in Event Log. Source: MSSQLSERVER A fatal error occurred while reading the input stream from the network. The session will be terminated. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Has anyone...more >>

If I run DBCC MemoryStatus and I get a negative value for Stolen in the Buffer Distributions section, what does a negative value indicate? For example: Buffer Distribution Buffers ------------------------------ ----------- Stolen -228001 -- Message post...more >>

Hi, Our db server appeared to hang during a long running script last night. Our windows guys rebooted the server. However my suspicion is that the script was consuming all systems resources but was still running. The SQL server is set to use all CPUs (4) and max all memory. It also has rai...more >>

Hi All, When using SQL profilter, I noticed that sp_cursorfetch has taken the most CPU and has the longest duration. I have searched on the Internet and found that sp_cursorfetch is used by server cursor which may be created automatically when client queries the server. Can we disable serve...more >>

Minimum password length for SQL Server Authentication and special character – how to set? I need to set that minimum password length for 8 char and password should include special character in SQL (2000) Server Authentication – is it possible? How to set it?...more >>

Hi All, We recently upgraded a box running Windows Server 2003 SP1 with SQL Server 2005 SP1 to Windows Server 2003 SP2 and SQL Server SP2. For some time we have had the following backup regime for some SQL Server full recovery model databases that are present on this server: ...more >>