Viewing 15 posts - 766 through 780 (of 1,048 total)
With 2008 you do it with "facets". Right click on the server instance in the SSMC and select facets......
The probability of survival is inversely proportional to the angle of arrival.
October 15, 2010 at 9:06 am
who is the database owner? That login was evidently mapped as dbo.
The probability of survival is inversely proportional to the angle of arrival.
October 14, 2010 at 10:22 am
Hmmmm. At this location I am the only DBA, but also am a .NET developer about 1/3 of the time as well.
We have about 20 front line SQL servers, 3...
The probability of survival is inversely proportional to the angle of arrival.
October 13, 2010 at 2:27 pm
These situations are similar to what you would encounter when multiple users attempt update to the same row on the same table on the same server except you have the...
The probability of survival is inversely proportional to the angle of arrival.
October 12, 2010 at 7:51 am
Okay, I understand your question now. It appears that the implicit conversion from (n)varchar() to uniqueidentifier involves only the first 32 valid hexadecimal characters and SQL server ignores the rest.
That...
The probability of survival is inversely proportional to the angle of arrival.
October 12, 2010 at 7:22 am
you'll need to create a new table and insert the date from the old one.
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 2:26 pm
I'm a bit confused by your sample TSQL code.
The local variable @ID that you are initializing with what appears to be a comma separated string of UIDs would never be...
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 2:23 pm
If I understand what you are saying, you want a list of ReportIds from all 100 tables that have a matching reportID row in the finalTable. If that is the...
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 12:23 pm
How about this:
update TBL set kPageName = '---'
from yourTable TBL
join (select (min(kPriority) as pri, kPageId from yourTable group by kPageID) LP
ON TBL.kPageID = LP.kPageID and TBL.kPriority > LP.pri
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 12:12 pm
Read this: http://msdn.microsoft.com/en-us/library/ms190919.aspx
regarding ramification of using -c switch
What I am implying is that a different codepage is in effect when it is run from the command line (shell) versus...
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 8:19 am
try specifying a different value for the -C (codepage) option.
The probability of survival is inversely proportional to the angle of arrival.
October 11, 2010 at 8:05 am
How to interpret that also depends upon whether you are running in a 32 bit Vs. a 64 bit OS.
The probability of survival is inversely proportional to the angle of arrival.
October 8, 2010 at 9:44 am
I don't have an answer except to suggest that you use bcp utility instead. It provides for saving a detailed error message regarding the data issue that is failing.
We use...
The probability of survival is inversely proportional to the angle of arrival.
October 8, 2010 at 9:39 am
how does the hardware of this new server compare to the old one? How much memory? How many drives? Is tempdb on its own drive array and have you set...
The probability of survival is inversely proportional to the angle of arrival.
October 8, 2010 at 9:28 am
what does it say in the event log?
The probability of survival is inversely proportional to the angle of arrival.
September 28, 2010 at 12:00 pm
Viewing 15 posts - 766 through 780 (of 1,048 total)