Viewing 15 posts - 1,561 through 1,575 (of 2,268 total)
Dont use cursors they will perform horrblbly, try and look for a set-based solution.
If you post your table defs , some sample data and what you want to...
February 20, 2009 at 7:27 am
Put the error on the data conversion task, as this will be where the data type error will be raised
February 20, 2009 at 2:04 am
It could be a permission issue, is the owner of the log job the same as the full backup job?
I have had Maintanence plans corrupt themselves before without any logical...
February 19, 2009 at 10:22 am
Is your error redirect on the data conversion task?
February 19, 2009 at 9:47 am
when you say
(Again, I'm talking about the size of file representing the dump of the transaction log not the size of the transaction log itself.)
Do you mean the transaction...
February 17, 2009 at 4:18 am
to check for database corruption run a DBCC CheckDB first
DBCC checkdb('YourDB') WITH ALL_ERRORMSGS, NO_INFOMSGS
The results will determine how badly the database is corrupted, then there are a number of options...
February 16, 2009 at 3:29 am
you cant convert a .bak into csv, xls or anything.
The way to export your data to excel is to use SSIS to build an export package from SQL server, there...
February 13, 2009 at 6:40 am
What country are planning on attending University, or is this a world-wide search?
February 12, 2009 at 8:37 am
Either Detach the database from 2000 and then re-attach to the 2005 system, and make sure you copy the logins over
Or if you can not afford any down-time then restore...
February 12, 2009 at 6:56 am
There could be a problem with using non-sargable where conditions on your query.
Rather than writing the where conditions with the funciton on the left, try re-writing them using is null...
February 10, 2009 at 9:30 am
It is possible to look at the log, but you will need to buy some software to enable you to do this as the log is very complex and cannot...
February 10, 2009 at 5:16 am
Alternatively you could use SSIS for this taks, you can put your procedure in the data source and send the data to a FTP destination.
February 9, 2009 at 9:15 am
Use an ODBC conneciton to the .DBF file, if you do not have the driver for this then it shouldn't be an issue to download it..
February 9, 2009 at 7:57 am
I think that the Inside Microsoft SQL Server series by Itzik Ben-Gan are some of the best books around for learning the fundamentals of SQL programming.
http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2005/dp/0735621977/ref=sr_1_1?ie=UTF8&s=books&qid=1234187520&sr=8-1
February 9, 2009 at 6:53 am
Back-up your transaction logs regularly and this will truncate them allowing for the free space to be re-used
February 9, 2009 at 6:40 am
Viewing 15 posts - 1,561 through 1,575 (of 2,268 total)