Viewing 15 posts - 3,331 through 3,345 (of 9,643 total)
What have you done to verify that the file is not in use by another process?
Can you provide the OS?
February 2, 2010 at 8:48 am
Here are a couple of blog posts that are good reads for selecting indexes:
February 2, 2010 at 8:47 am
Not minutes from 1/1/1970 as that puts you in the 4000's. Could be seconds though.
Overall this is a mystery and you need to find someone involved in creating...
February 2, 2010 at 8:43 am
SSIS is a a good tool to do that. IF you aren't doing any other transforms to the data then the bcp utility or bulk insert might be a...
February 2, 2010 at 8:32 am
I'd use a tool like RedGate SQLCompare or Apex SQLDiff.
If you have to have a script, this should get you started:
SELECT
T.name AS table_name,
...
February 2, 2010 at 8:28 am
Assuming you are using a table, if you have group/table headers and put the fields you want aggregated into the header you will get aggregated data. You can change...
February 2, 2010 at 8:12 am
You can specify the collation at the database level. Check out the Create Database entry in BOL.
February 2, 2010 at 8:10 am
I've tried to cast the varchar field, as other forum entries suggest, to datetime but get a conversion error:
Conversion failed when converting datetime from character string.
This says that you have...
February 2, 2010 at 8:08 am
I've found a couple of instances where this was caused by an error in the installation of SP2. SP2 reports it succeeded, but there are a couple of scripts...
February 2, 2010 at 7:55 am
I usually use a data conversion task to transform the data to the expected data type, unless I can change the destination to the source data type.
February 2, 2010 at 7:49 am
That could potentially be a busy trace. It depends on the number of admins you have, if any applications are running under sa or a sysadmin account, and how...
February 1, 2010 at 8:23 pm
The default trace "may" have the information needed, but, this according a MS in a connect item, the "default trace is not for security auditing", so you probably need your...
February 1, 2010 at 7:53 pm
You need to do a command line install and include the SKUUPGRADE parameter. See this article.
February 1, 2010 at 1:56 pm
If you have the option to improve performance and data integrity by adding foreign keys and indexes to the current database I would start there.
You also have to...
February 1, 2010 at 7:11 am
Viewing 15 posts - 3,331 through 3,345 (of 9,643 total)