Viewing 15 posts - 26,761 through 26,775 (of 39,792 total)
What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.
October 10, 2008 at 8:53 am
smithsjt has it right in that if you have the junction table, you have a many to many.
For a one to many customer to salesperson, you really have CustomerID in...
October 10, 2008 at 8:52 am
It marks all committed records, which were backed up, as free, which is the same as truncate. It does not change the file size from the OS side. Internally the...
October 10, 2008 at 8:49 am
To move logins, get sp_help_revlogin from Microsoft, which will script out the logins with the same password.
October 10, 2008 at 8:41 am
I'm not sure what you mean about the upgrade. Did you mean update?
The update changes the field specified only. If there is a username field in the web table, it's...
October 10, 2008 at 8:40 am
The link has been corrected in the article.
October 10, 2008 at 8:23 am
I'd go with those. sqlSentry has a performance monitor that looked outstanding when I saw it at TechEd.
October 9, 2008 at 12:20 pm
RESTART
Note:
Supported only by RESTORE.
Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts...
October 9, 2008 at 12:20 pm
I wouldn't go to a NAS. Asking for issues. Any network hiccup and your backup fails. And it will fail the day you need to restore. Disk is cheap. Get...
October 9, 2008 at 12:18 pm
I thought it was about 30-35 multiple choice and 12 sims, but I could be wrong. It's been well over a year for me.
You need to be familiar with SSMS,...
October 9, 2008 at 12:17 pm
Use EM, right click the database and select Generate Scripts.
October 9, 2008 at 12:09 pm
Nope, no limits on accounts. Must be something else, though I'm not sure what.
What is the error in connecting? Can the 2nd person connect with other credentials?
October 9, 2008 at 10:10 am
Wow, why not use an identity here? You're reinventing a wheel you don't need to.
The other thing you can do is raise a semaphore. The first line in the proc...
October 9, 2008 at 10:09 am
Adi is correct, SQL Server, and all applications get their time from the OS of the machine where it is installed. If you are on your workstation with SSMS and...
October 9, 2008 at 9:50 am
Can't find anything with searching and not sure what these are for. Hopefully someone will reply. What type of data is in there?
October 9, 2008 at 9:46 am
Viewing 15 posts - 26,761 through 26,775 (of 39,792 total)