I'm designing a report using Reporting Services 2000. The data source is based on a stored procedure. There are two data parameters - a start date and end date. If a normal start and end date is provided (such as 4/1/09 and 4/20/09) the proc returns a description and a record count for that...
Is it possible that the code below is causing deadlocks because of how it's written? Meaning, the table being updated is also referenced in a subquery within the update statement. We know deadlocks are occurring on the tables and this stored procedure was captured in an SQL profiler trace. Would...
System: SQL Server 2005 SP2
We recently discovered a stored procedure containing a large complicated select statement. When the stored procedure is executed by one person, the select statement shows up in an SQL Profiler trace about 500 times. The EventClass I used is "SP:Completed". The...
Is it possible to install SQL Server 2005 Reporting Services Standard Edition on one server and install the database engine (SQL Server 2005) Standard Edition on a separate server? I'm concerned about it being Standard edition. Will this work?
Thanks!
Is it possible to create an indexed view in SQL Server 2005 on a table that resides in an Oracle database? If so, how would you go about doing so? Using a linked server?
Thanks!
Hi everyone,
When we back up SQL Server 2000 databases, we use the following t-sql statement. Does anyone see anything majorly wrong with it?
BACKUP DATABASE [MyDB] TO DISK = N's:\ MSSQL\Backup\MyDB.dat' WITH INIT , NOUNLOAD , NAME = N' MyDB backup', SKIP , STATS = 10, DESCRIPTION =...
Hi everybody,
I'm a bit confused about how to proceed with SQL Server 2005 hotfixes.
Most of our servers that have SQL Server 2005 have build 3159. I know there's a new security hotfix out (bulletin MS08-040) which we need to apply to our SQL servers. For those that currently have build 3152...
Hello!
We have SQL Server 2005 Enterprise Edition SP2. Does anyone know if database mirroring will work okay with RSA SecurId?
I tried Google'ing it and searching on the RSA SecurId website but couldn't really find anything. I'd appreciate any comments on it.
Thanks!
Hello,
I have a fairly basic report (no headers, footers, or subreports) I created using Reporting Services 2005. It contains a few tables and a couple of report parameters.
I need the report to display a message when there is no data. I created a simple dataset (select 1 as datavalue) and...
Hello all!
I’ve been Google’ing and reading up on SQL Server and memory since yesterday and am very much confused. Hopefully someone can help clarify a few things for me.
We have a production cluster (active/passive) running SQL Server 2000 Enterprise SP3a (vs 8.00.818) on Windows Server 2003...
Hello!
We have a stand-alone server running SQL Server 2005 SP2 for a specific application. It contains a database that has 90+ tables. Of these tables, about 30 have insert, update, and delete triggers. They are After triggers and are being used for audit purposes. Meaning, whenever someone...
Hello all!
We have an automated process that copies SQL backup files from our production SQL Server 2000 server (sp3a) to a disaster recovery server (also SQL Server 2000 sp3a) nightly. There is a job that restores all 100+ databases on the disaster recovery server and fixes the orphaned users...
Hello!
We're in the process of migrating to SQL Server 2005 x64 Enterprise from SQL Server 2000 x86. None of the applications run on the database server. Everything connects remotely to the databases. We have a vendor that says their application supports SQL Server 2005 but "the 64-bit...
Hi everyone,
I was recently asked to maintain a new server that is running SQL Server 2005 (no service packs) which was setup by a vendor. So I started looking through it and found a few interesting things that I thought I'd ask about. Note: I already told them that it needs SP2.
They had...
My colleague and I have been researching this topic all afternoon and have become quite confused.
We're going to be migrating our development server soon to SQL Server 2005. The transaction level is fairly small on any given day. So performance isn't really an issue for us on this particular...
Hi everyone!
This question involves a server running SQL Server 2000 (SP3a).
I noticed this morning that we have a couple of processes in the sysprocess table that show a hostname of "127.0.0.1" (i.e. localhost). This server is configured to run and listen on an actual IP address. Does anyone...
Hello all!
I’m having some problems with a basic maintenance plan on a server running SQL Server 2005 SP2. What it boils down to is that I can’t get the maintenance plan to run. It won’t run when I manually execute it (right click on the name under Maintenance Plans and select Execute) and it...
Hi everyone!
I have a silly question. I haven't been able to find the answer yet (short of calling Microsoft) so I'm hoping someone can help.
Is it possible to still buy SQL Server 2000 licenses?
Thanks!
Hi everyone!
I'm having another problem and can't seem to find what I'm looking for. Hopefully someone can give me some advice.
We're running out of space on the C drive of a 64-bit Windows 2003 Server (virtual). The maximum space is 10 GB. We have SQL Server 2005 (sp2) installed along with...
Hi to all!
We have a linked server defined within a SQL 2000 server. The remote server is a SQL 2005 server. I don't think the link is being used. How can I find out if anyone is using it? I want to delete it if it's not being used.
Here's the main situation:
Our main SQL database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.