Viewing 10 posts - 1 through 10 (of 10 total)
Agreed. I am challenged with similar issues here. If you can create roles, then make use of that as well. We have done that here and then...
April 27, 2006 at 10:31 am
If you have a particular database, or group of databases, you use regularly you can modify the properties of your shortcut in the quick launch bar (or your desktop, for...
October 12, 2005 at 8:27 am
Sometimes, I come across this issue as well. Ask the developer if he/she has modified his/her ODBC connection. If they modified the ODBC and are trying to connect differently, then...
January 19, 2005 at 8:06 am
I have had replication stop on me as well. To ensure that the distributor is running, I created another schedule to run every 5 minutes and enabled it....
January 18, 2005 at 10:29 am
Going back to the derived column names (column aliases)...replace ClosedTot with the actual formula as below. I have had QA bark at me when I've used the alias rather than the...
December 15, 2004 at 8:11 am
Hmmm...gotta think about this one for a while.
1. Can you open the file in notepad? If you can, I presume it will be in binary. Can you read binary? ...
May 18, 2004 at 1:00 pm
Have you tried the bulk insert without the "with"?
BULK INSERT tempdb.dbo.TEMP_PERFMON_OUT
FROM '<YOUR_FILE_NAME>.txt'
May 18, 2004 at 12:29 pm
Sure. With my first suggestion, you would need to modify each cell individually. With my second thought, you could create a temp table, import the file's data into...
May 18, 2004 at 7:53 am
Another thought...have you tried to Bulk Insert your output ( presuming it was saved electronically) into a temp table, then do a select, converting the binary to char or varchar? ...
May 17, 2004 at 3:47 pm
You could try to copy and paste your results into MS Excel, then convert it to decimal.
The formula is =BIN2DEC (binary result). You may need to go to TOOLS, AddIns...
May 17, 2004 at 3:35 pm
Viewing 10 posts - 1 through 10 (of 10 total)