Viewing 15 posts - 17,281 through 17,295 (of 26,489 total)
Does this help get you in the right direction?
declare @ TestStr varchar(32); -- to get this to post, I added a space between @ and TestStr, remove that space
set @TestStr...
January 22, 2010 at 10:06 am
Look for: linked servers [SQL Server], ODBC in BOL (Books Online).
You use the OLE DB Provider for ODBC when creating a Linked Server that uses ODBC.
January 22, 2010 at 9:59 am
Adam Machanic (1/22/2010)
Jeff Moden (1/21/2010)
January 22, 2010 at 9:09 am
Thank you for stating you are using SQL Server 2000 in your initial post. Please, in future, be sure you post your questions in the appropriate forums as this...
January 22, 2010 at 8:16 am
Please take a close look at the code I have provided. In it you will see that I have provided you with the CREATE TABLE statement and the INSERT...
January 22, 2010 at 8:06 am
The problem is the datatype you are using for amount. Here is some code I put together that appears to work, give it a try.
SELECT
supplier,
...
January 22, 2010 at 7:41 am
CirquedeSQLeil (1/21/2010)
It was cheaper back when I was interested in attending there.There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program
Can't do that....
January 22, 2010 at 4:38 am
CirquedeSQLeil (1/21/2010)
Community college and clep your way through most of the credits - could get a lot of degree for that:-DMIT - you might get a few semesters.
Not even close:
Nine...
January 21, 2010 at 10:40 pm
Jeff Moden (1/21/2010)
GilaMonster (1/21/2010)
Jeff Moden (1/20/2010)
I'd suggest the relatively new "master DBA" cert. I've forgotten exactly what's it's called but it's similar to what I've just called it.
Microsoft...
January 21, 2010 at 8:56 pm
Dumb question, but I'm going to ask it any way, why doesn't the insertiong of code C automatically update the effective date (Valid_To) of code B? That, to me,...
January 21, 2010 at 3:51 pm
SQL_Quest-825434 (1/20/2010)
Lynn Pettis (1/20/2010)
shripati (1/20/2010)
You can try this steps:
Truncate the log file --- and shrink it to minimum size possible.
This is the code...
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH...
January 21, 2010 at 3:14 pm
Found on Redgates' site via Google:
505 -
No SQL Backup file name entered.
Check that the length of the path name does not exceed the number of characters for your...
January 21, 2010 at 3:11 pm
GilaMonster (1/21/2010)
Setting max memory...
January 21, 2010 at 12:53 pm
Only suggestion I will make, set max memory to 6144 MB. This will leave 2 GB for the OS. Depending on whatever else you may be running on...
January 21, 2010 at 12:22 pm
david.wright-948385 (1/21/2010)
Lynn Pettis (1/21/2010)
Again, NOPE. Luck implies a total lack of knowledge.
Luck (in this case) means you got the right answer without taking all the issues into consideration. You...
January 21, 2010 at 11:51 am
Viewing 15 posts - 17,281 through 17,295 (of 26,489 total)