Viewing 15 posts - 4,231 through 4,245 (of 7,429 total)
Sorry, did not exactly state right, you just have to have a Certificate instaled on the IIS server for your site. I used Certificate Server to generate my own internally,...
November 20, 2002 at 6:02 pm
Hot Fixes are not generally tested as well as most SPs, so I wait a week or so before I install. Unless I feel I may be directly vunerable in...
November 20, 2002 at 5:56 pm
MSDTC is tied to Component Services. Check the Event Viewer Logs right after trying to start and see if any more details messages are available. Also, what is the full...
November 20, 2002 at 5:53 pm
The only problem when I thinking about it, with using initials is it makes it harder to code as you have to go look up the SP name. What do...
November 20, 2002 at 5:46 pm
Duplicate post, please see response in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8295&FORUM_ID=5&CAT_ID=1&Topic_Title=Week+number+and+datepart&Forum_Title=Administration
November 20, 2002 at 7:19 am
Maybe something like this is what you are looking for.
SELECT
CASE
WHEN
(DATEPART(wk, 'PutDateHere(Ex.2/14/2005)') - (CASE WHEN DATEPART(dw, 'PutJan1ForThatYearDateHere(Ex.1/1/2005)') > 3 THEN 1 ELSE 0 END)) = 0 THEN 53...
November 20, 2002 at 7:17 am
1/ 3 things, check the MSDB database for the backup set this should help but still needs some work.
select
database_name,
[name] backup_name,
[description] backup_description,
case device_type
WHEN 5 then 'Tape'
WHEN 2 Then...
November 20, 2002 at 7:08 am
First off SA is a member of the System Administrators role and has access to all things. You cannot use EM to drop it, however haven't tried and wouldn't but...
November 19, 2002 at 7:28 pm
quote:
The "Basic Authentication" I understand broadcasts the user and password as clear text, so probably not a good choice for an Internet,...
November 19, 2002 at 7:20 pm
No but see if either of these threads are helpfull.
November 19, 2002 at 7:11 pm
Got to looking at the documentation and I understand we are misreading it now. When it says
quote:
The KillDatabase method drops a...
November 19, 2002 at 2:43 pm
I would need to see how you tested and got the results. Can you post the code you used to get your results and we can see if anything is...
November 19, 2002 at 1:41 pm
Can you give a bit more detail on what you are trying to do and how the server is configured. Sounds like you set the database into standby.
November 19, 2002 at 5:23 am
Server versions have to be the same to accept a Master restore. Not sure what you me by file structure.
November 19, 2002 at 5:18 am
I always test any solutions I come up with and compare. The Coalesce may have been a little faster because a reuseable plan was available so not really a fair...
November 19, 2002 at 5:16 am
Viewing 15 posts - 4,231 through 4,245 (of 7,429 total)