Viewing 15 posts - 5,026 through 5,040 (of 6,400 total)
No, you cannot use a Standard licence for a Enterprise server.
You could install SQL 2012 Standard, and uninstall SQL 2008 Enterprise Trial
May 17, 2012 at 4:35 am
annoymous authentication to the web site - as it implies no authentication, everyone can see
forms based authentication - uses forms to authenticated to the web site
custom authentication - write your...
May 17, 2012 at 4:18 am
the only way to change a column from DateTime to INT would be to drop and re-add the column as its an explicit conversion
May 17, 2012 at 4:03 am
ALTER TABLE is implicit based, if you look at the CAST CONVERT MSDN page, DateTime to INT has to be explicit so you need to do CONVERT(INT,Dtt) but you cant...
May 17, 2012 at 3:50 am
This should do the trick, also dont forget the power of Google or your favourite search engine
set datefirst 1
DECLARE @dt DATETIME, @WeekOfMonth TINYINT
SET @dt = '2007-07-08'
SET @WeekOfMonth = DATEDIFF(week, DATEADD(MONTH,...
May 17, 2012 at 3:23 am
David, your getting confused over blocking & locking and deadlocks, what you are seeing is typical behavour within SQL and is blocking as two sessions are waiting for the same...
May 17, 2012 at 2:57 am
What I think John is getting at is which is quicker?
In the example I have used I say 2 hours to perform the index rebuild, so it takes 2 hours...
May 17, 2012 at 2:44 am
what is under the alerts folder in SQL Agent?
do the other people know how the alerts are setup?
do you need adding to an operator?
May 17, 2012 at 2:07 am
what alerts have you missed? how are they configured? where do they pick up the email address settings from? do all alerts send to the same people all...
May 17, 2012 at 1:50 am
you can send me a private message on here or keep posting to the forum. I would recommend the forum so that if anyone else has the same issues...
May 17, 2012 at 1:48 am
This will point you in the right direction if you dont have the traceflags enabled on your instances
http://msdn.microsoft.com/en-us/library/ms186385.aspx
Will need to refactor the job to send the mail, or get it...
May 17, 2012 at 1:45 am
Yes you can do that but you will still have sync issues as your not really changing anything which isnt already setup automatically.
Your still in the situation where if the...
May 17, 2012 at 1:42 am
can it connect to SQL?
No - Problem with the server principle (doesnt exists/set to deny connect/password expired/wrong password..... there are many different causes)
Yes - No problem
can it connect to the...
May 17, 2012 at 1:20 am
It can certainly cause sync issues in terms of it has to rebuild the index on the secondary server due to the operation being logged, so if an index rebuild...
May 16, 2012 at 8:04 am
ChrisM@Work (5/16/2012)
anthony.green (5/16/2012)
May 16, 2012 at 7:45 am
Viewing 15 posts - 5,026 through 5,040 (of 6,400 total)