Hi, I have set a linked server sql2k sp3 in another sql2k sp3.. when i try to run a job I'm geting the following error:
The operation could not be performed because the OLE DB provider 'SQL...
In the SQL Server Service Manager I keep getting this error message. "The service did not start due to a logon failure."
Then I click OK, and I get this message
"Error 1069- (The service d...
(This is tangentially related to http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21182188.html)
Can anyone confirm whether it's possible to combine "standard" SELECT statem...
Hi,
I need to query a temporary table in a function which is being populated in some stored procedure. The call hierarchy can be understood as follows.
create procedure sp_PopulateT...
I got this message when booting up. Now, I cannot use SQL Server at all. I get the same message when I try to connect to the server. The only recent change has been the installation of MSDE...
I am looping through a list of tables in a cursor, and for each table name I fetch, I need to check whether a particular column exists and do something if it does NOT... here is the basic synt...
This is the following error that i get.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver spe...
I am receiving the following error message in the SQL Server Error logs:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
and ...
Hello Experts, I have a varchar column that contains both strings and integers stored as strings (see sample below). I would like to select the ones that can be easily converted to INT withou...
What are the disadvantages of indexing (non-clustered)? I have a table (7 fields) which stores student information (first name, last name, gender, etc). I also have a web based .NET applicat...
Hi there,
We are running MOM and having problems with the database. The log file reached 86GB and filled up the whole of the D Drive it was living on.
I wanted to take a backup of the databa...
Microsoft SQL-DMO (ODBC, SQLState:01000)
Error 926: Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
I have virtually no practical knowledge for SQL, so I could re...
I have a SQL Server that has been working fine for the past year. But all of a sudden when I rebooted my server I got this error:
"The SQL Server (TESSI2005) service terminated with servic...
On Oracle I can query from multiple columns in a subquery like so:
[code]
SELECT row4 FROM mytable WHERE (row1,row2,row3) IN (select row1,row2,row3 from mytable)
[/code]
How do I do th...
I'm doing a data conversion. I need a select statement to create a number of rows of data. One of the columns in the row needs to be an incremental number starting at 6000.
For example if m...
Looking for a stored procedure that will copy a row from one table to another. The row has a unique id field called id. If the row exists in the target the procedure should do an UPDATE. Ot...
Hello,
I installed SQL Server 2005 but had some issues so had to remove it. So i uninstalled it and tried to reinstall
everything worked properly but when i try to install reporting servic...
i'm trying to pull data out of a column that looks like such:
(Open,7/15/2008 9:23 Open,7/15/2008 10:26 Assigned,7/15/2008 10:27 Assigned,7/16/2008 14:11 Closed,7/16/2008 16:22)
All i ...
Hello.
How do I open an XML file from inside a stored procedure? I've not used XML much, and am trying to bash my way through this, but all the examples I'm seeing aer showing me how to ret...
Hi All,
Our terminal server (Windows Server 2003 R2 Standard) is currently allocating a high amount of memory to the sqlservr.exe process.
At present the server is very sluggish, and the p...
Hi,
this morning I discovered that it wasn't possible to make Inserts anymore because there was a File which grew to > 61GB:
D:\sqldata\MSSQL\LOG\SalesLogix-LOG
which took all the HD s...
I've create a tablix report in SSRS 2008 that ends up being several pages when rendered. I want the column headers to repeat on each page so my users know what they're looking at. The MSSQL ...
Hi All,
I have a database which has every table prefixed with 'tbl_' and I would like to remove this. The problem is that there are stored procedures and triggers linked to these tables. ...
Hi,
I want to execute a dynamic sql query then loop through the results (and perform other queries) within a single stored procedure
the following code tells me theres an error before th...
Greetings,
I am looking for how to get the following 6 date ranges:
1) This week (first day(su), last day(sa))
2) Last week (first day(su), last day(sa))
3) This month (first day, last...
