Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fuzzyocelot

    Invalid attempt to read when no data is present

    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...
  2. fuzzyocelot

    Subquery Causing Deadlocks?

    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...
  3. fuzzyocelot

    Trace Shows Statement Executing Thousands of Times

    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...
  4. fuzzyocelot

    Reporting Services 2005 Standard Edition with Remote Database (SE)?

    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!
  5. fuzzyocelot

    SQL Server 2005 Indexed View on Oracle Table?

    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!
  6. fuzzyocelot

    SQL Server 2000 Database Backup File Missing Indexes when Restored?

    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 =...
  7. fuzzyocelot

    SQL 2005 Hotfix Confusion

    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...
  8. fuzzyocelot

    Database Mirroring and RSA SecurId?

    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!
  9. fuzzyocelot

    NoRows Not Working

    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...
  10. fuzzyocelot

    Extremely Low Page Life Expectancy

    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...
  11. fuzzyocelot

    Need Help to Find Problem Trigger

    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...
  12. fuzzyocelot

    Refreshing 200+ Passwords

    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...
  13. fuzzyocelot

    SQL Server 2005 x64 Not Supported

    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...
  14. fuzzyocelot

    Strange SQL Server 2005 Maintenance Plans

    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...
  15. fuzzyocelot

    System Databases' Location

    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...
  16. fuzzyocelot

    Question about SysProcesses

    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...
  17. fuzzyocelot

    SQL Server 2005 Maintenance Plan Error: Login Timeout Expired

    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...
  18. fuzzyocelot

    SQL Server 2000 Licensing

    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!
  19. fuzzyocelot

    Need to Move Workstation Components - Help!

    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...
  20. fuzzyocelot

    Linked Server – How to Determine if Anyone is Using It?

    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...

Part and Inventory Search

Back
Top