Viewing 15 posts - 2,146 through 2,160 (of 9,715 total)
This sounds somewhat like homework. But since you've posted what you've tried...
Break down your problem. Don't do it all at once.
Let's start with the first concern. Here we need...
November 23, 2015 at 6:29 am
Sysaltfiles is also a SQL 2000 deprecated table included only for backward compatibility. If you answer Gail's question, we may be able to assist you with an alternative.
November 23, 2015 at 6:19 am
Hey, guys, we have a language conversion question over here. Can anyone assist with this?
November 23, 2015 at 6:15 am
Glad we could help. Let us know how it goes.
November 23, 2015 at 5:06 am
jasona.work (11/20/2015)
3-6", and it looks like they're predicting it'll be that nasty rain...
November 20, 2015 at 6:43 am
Nothing like staying up late two nights in a row to do releases, get called back ten minutes after the second release to be told I forgot to move scripts,...
November 20, 2015 at 6:07 am
Phil Parkin (11/20/2015)
There are many more but, just to wet the appetite for other possibilities...
Sounds a bit too damp for my liking. 'Whet' is the word I think you were...
November 20, 2015 at 5:25 am
SQL Galaxy (11/20/2015)
Pl. correct me, if I am wrong comments.That windows login already have sysadmin permission then no need to mapping any database that user.
Thanks
You are not wrong. Usually.
There...
November 20, 2015 at 5:23 am
Luis Cazares (11/19/2015)
Brandie Tarvin (11/19/2015)
Bah. I thought I was being clever, but I have an error I can't find.
I made the code work by adding 4 characters in different parts...
November 19, 2015 at 12:33 pm
Bah. I thought I was being clever, but I have an error I can't find.
November 19, 2015 at 12:17 pm
HA!
DECLARE @CurrentTime DATETIME, @TallyCount INT, @Adhoc_SQL NVARCHAR(50);
DECLARE Time_Cursor CURSOR FOR
SELECT DISTINCT N FROM dbo.Tally WHERE N < 500
-- Open Cursor of Users
OPEN Time_Cursor
FETCH NEXT FROM
Time_Cursor
INTO
@TallyCount
-- ...
November 19, 2015 at 12:11 pm
Luis Cazares (11/19/2015)
jasona.work (11/19/2015)
So I'm posting it...
November 19, 2015 at 11:15 am
Sounds like an orphaned user to me. Check the database level security and the server level security in the GUI. Remove the database level security, then go to the server...
November 19, 2015 at 5:42 am
Is this in production or a non-prod environment?
If production, you might want to have a discussion with your boss about the issues of giving DB create permissions in a production...
November 19, 2015 at 5:39 am
You may never find an issue to this answer. Sometimes Replication just stops.
The first places to check, though, would be the error logs (for any weird warnings or errors) and...
November 19, 2015 at 5:34 am
Viewing 15 posts - 2,146 through 2,160 (of 9,715 total)