Can you do an in place upgrade from SQL Server 2000 --> SQL Server 2008 or do you have to do a side-by-side upgrade?
Our networking guys are going to be doing some maintenance work that will cause our publishing cluster to lose connectivity with our distributor and...
I know you can house the reportserver and the reportservertempdb on a sql 2005 cluster and connect to them from another standalone SSRS...
Hi, We are running SQL Server 2005 sp3 x64 Enterprise Edition in a two node SQL cluster The application is 7X24 and we plan on locking the users...
Hi, Currently running sql 2005 sp3 x64 enterprise edition in a cluster (2 nodes). I created a user with only select access to one table and one...
Hi there, We have transactional replication running on a SQL cluster (2005 sp3) which failed over to the secondary node the other day. The fail over...
Hi everyone, Just wondering if anyone has seen this message and could tell me what it means. It is happening when I'm trying to upload files or...
Is it possible to install multiple instances of SSRS, have them load balanced and point them to the same ReportServer and ReportServerTemp db which...
Is there a way to compare the job entries in two separate sql server agents (different instances) other then "eye balling" them...possibly a query or...
Hi, I'm trying to create my subscriber by initializing it from a backup file. Within the publishing database I turned on 'Allow initialization from...
Does anyone know if you need a separate license for SSRS if you are installing that component on a separate server from the rest of the enterprise...
I'm running sql server 2000 sp4. I have sql mail working and sql server agent mail working. When I try to drag a sendmailtask into a DTS local...
Is there a way to export a database diagram to a .bmp or a .jpg file?
Hey there everyone. I was hoping someone could give me a hand with this. I have a production database that has a log file that has recently grown...
I have to change the email notification operator to a distribution list on a whole bunch of SQL Server Agent jobs. Can I just update the...
Just wondering if there was an easy way to send messages that normally show up in the messages tab under the results pane to a text file. I have a...
I created a sql server 2005 named instance on my current sql server 2000 production server. I completed the conversion and have turned off all of...
quick question... If you have a db set to 'bulk-logged', will an import using the DTS import/export wizard perform the same way as a bulk insert or...
Hi, I'm running a sqlserver 2000 sp4 db. One of our users was trying to create an ole db connection through crystal reports but it was not working...
Hi everyone, I was wondering what exactly is involved with changing the startup service account? I know that through Enterprise Manager on the...
Separate names with a comma.
