Hello,
I had a server crash on my old SQL2000 server. I was recover the database files and I attached them in a new SQL 2005 server. But I got only one problem. Most tables were created ...
I am getting an error involving the "=" in my SUM statement. The error doesn't change whether it is '1' or 1.
Unable to complete SQL 2005 SP2 installation on Windows Server 2003 SP1 Cluster. Some components failing including SQL Server and Client Tools. Log attached below:
Ran install using domain ad...
I am working on a stored proc to convert the comma delimiter to pipe delimiter. I noticed that any delimiter was not given at all the the code. So now I am adding another SELECT on the top of ...
I have the following sql statement:
SELECT nvarchar10, nvarchar11, nvarchar12, nvarchar13, nvarchar14, nvarchar15, nvarchar16, nvarchar17, nvarchar18, nvarchar19, nvarchar20, nvarchar21, ...
I am getting these informational event logs under the application events in windows 2003 server. Can someone shed some light here for me. These messages keep poping up every minute or 2 in t...
There is probably a very simple solution, but I just can't figure it out.
I've got 3 tables I am trying to query:
Table 1 has flat data
Table 2 has 8-10 records for each value in tabl...
Hey everyone,
I'm using SQL Studio 2005 and want to export the queries I run in the Analizer to Excel...including the column headers.
Do I set that in the options somewhere or code it?...
How do I load/run an sql script using sql query analyzer in sql server 2005.
Iam running sql2005 and I have a transaction log that did not have a maintenance plan on it so it was never truncated. It has grown to 112 gigs and I need to get it down in size. I have run ...
Hi,
I want to backup an existing database and restore it as a different database.
SQL Management Studio creates the following scripts...
Backup.
BACKUP DATABASE [STemplate] TO DIS...
I have a SSIS package that runs scripts (which create and populate a database) each night. The idea is to have a current copy of a DB from my client each night. Files are FTP'd to my server.
...
Hi,
I need to export multiple tables to csv files. These tables are extracts of data created using SQL Queries for the purpose ofexporting to csv files and sent to an external service center...
I'm using SQL Server 2005 with VB.Net. My question is related to Insert triggers in SQL 2005.
Is it possible to update columns of a new record during a Insert Trigger? When the new reco...
How can I write a code to drop a temp table ( #temp) if it already exist?
Is it possible and how to change a named instance of SQL 2005 Standard to the default instance?
Here is the scenerio: Currently, the server has SQL 2000 Standard installed. The client would...
I am having trouble getting my new webpage online, I am running into the following error...
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SER...
Running into "insufficient memory to run query" errors when performing scheduled maintenance tasks. I suspect this is due to improper configuration of memory or page file.
SERVER: 2003 64bit...
I am writing a script where I need to update two tables that reside on two different databases on two different servers. I am putting them in the same script and was wondering how I would go a...
I'm running SQL 2005 Management Studio on an XP Pro workstation and am running the following SQL Statement to prevent the insert of duplicate data from a Table called Software to a table calle...
I have a table in SQL 2005.
I have 4 columns, all DateTime
in1 out1 in2 out2
---
I want to do this: If any of the preceding values are bigger than the ones after, then the dates ch...
Hi,
Following an issue with one of our databases earlier today, someone attempted a restore from a file created from a maintenance job. They then stopped the restore as thet thought it wasn...
I have been trying to connect SQL Server 2005 via Linked Server connection to Active Directory and keep getting this error:
Msg 7321, Level 16, State 2, Line 1
An error occurred while prep...
We have installed a MS SQL Server in your department. I am wondering how I can get Nagios to monitor the MSSQLSERVER service?
Thanks,
Mikie
Hello all,
The HDD that holds the logs for one of our DB servers has run out of space (More has been ordered). Part of the reason for this is the log files have gotten rather large, as such...
