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 have a file located at c:\mydb.7.7.2006.bak. I need to restore it to a location on my local computer running win xp with sql express.
Here is what I have done:
restore filelistonly
...
Hi,
I have a DATETIME field:
SELECT DATEFIELD
FROM TABLE1
DATEFIELD has fields like: 11/11/2004 10:20:32 PM
How would I remove the date part (11/11/2004) and keep only the time, bu...
Greetings!
I've written a stored procedure which pulls data and dumps it into a temp table...however, I'm trying to figure out if its possible to send the data (hundreds of rows) to a text ...
Hi ,
I have a VB program which access MS SQL Server.Sometimes the program encounter this problem.
Error:[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network docu...
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...
Hi, I'm getting the foloowing error:
"The database owner SID recorded in the master database differs from the database owner SID recorded in database 'mydatabase'. You should correct this si...
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...
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...
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...
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...
I am in the process of upgrading the default instance of SQL Server 2000 to SQL Server 2005 on Windows Server 2003 SP2 machine. This server is set to mixed authentication and all passwords fa...
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...
Hi,
I hope someone out there can shed some light on what is going on here.
We have a Java application which is running for 24 hours and we have implemented our own connection pooling. ...
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 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...
My stored porcedure receives a very large number as a string something like this:
'123456789333501E+15'
and I need to convert that to a numeric value with 25 digits but if I try and call...
How do I convert a field with the type of datetime to int ?
I need to convert the data it contains too.
Thanks !
We get these periodically on servers distributed across our environments. In particular, this pertains specifically to some SQL 2000 servers that are in a different subnet then my DC's. Look...
Hi, I can limit the rows by the rowcount with the following code, but how can I get the row count with the same query. I don't want to run another query because of performance issues.
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...
I'm trying to write my first ever stored procedure and I get an invalid obect name 'dbo.spRPT.rptSLR_Imprt_LC' when I try to run it. I have pasted my stored procedure below. What am I missin...
Hi,
I want to know is there any command in T-SQL have the same function like VB5;
Do until resultset.EOF
.......
resultset.movenext
Loop
I have declare a cursor for a ...
Hi All,
I am needing to create a temp table using Where NOT EXISTS. I am trying to compare data from the temp table and a permanent table to see how much data is missing. What am I doing...
