Viewing 15 posts - 5,446 through 5,460 (of 7,429 total)
I am familiar with the code for doing a verification of a password in regards to NT. It should be simple enough to create an extended stored procedure to submit...
June 14, 2002 at 12:33 pm
When you say a lock shared locks are common as it reads the data and doesn't want to pickup uncommitted items. What type are you seeing?
"Don't roll your eyes at...
June 14, 2002 at 12:08 pm
Should not be affected unless you log SQLAgent logining in with SA. In that case all jobs should fail.
"Don't roll your eyes at me. I will tape them in place."...
June 14, 2002 at 11:59 am
Yes, SQL only check if valid at startup so only one check of it anyway. Should be a non-issue.
"Don't roll your eyes at me. I will tape them in place."...
June 14, 2002 at 11:55 am
Right the data should be fine, however user logins may be another issue. If you rebuild the logins you can use sp_change_login with autofix (see BOL) to sync them. That...
June 14, 2002 at 11:53 am
quote:
The funny thing about that way is if you put the 10< before your second select it would run for 7...
June 14, 2002 at 11:44 am
Structure changes occurr to DB's when restored to a 2000 server from a 7 backup that I believe will prevent this from being able to be moved back. I suggest...
June 14, 2002 at 11:31 am
Sorry I was thinking physical file not logical file. Brain on vacation. As for being able to rename logical I don't believe you can. Even if you run EXEC master.dbo.sp_configure...
June 14, 2002 at 8:01 am
Your statements are correct except last.
1 yes,
2 yes,
3 Might be able to use WINS to generate and alias or LMHOST file on the machines (but that is...
June 14, 2002 at 6:32 am
If the file is small the easiest and surest way I found was to do a file backup of the database then restore. When you do the restore in EM...
June 14, 2002 at 6:29 am
There is a drop box above the index area that states "Active Subset" set to (Entire Collection)" to get all available.
"Don't roll your eyes at me. I will tape them...
June 14, 2002 at 6:26 am
The answer to the original question is you cannot force a login prompt unless they are not logged into the domain and the machine is set up to access the...
June 14, 2002 at 6:22 am
I have had this before and this should correct.
Stop SQL Server
Find tempdb.mdf and templog.ldf (usually in the data folder unless you moved).
Delete both (SQL automatically rebuilds these every restart but...
June 14, 2002 at 6:20 am
One account is easier to maintain and be sure consistant (except you will have to keep up with the password). The other method works fine as well just requires you...
June 14, 2002 at 5:50 am
quote:
Another question (as if I have not asked enough, but I am new to SQL Server and the big guy has thrown...
June 13, 2002 at 8:00 pm
Viewing 15 posts - 5,446 through 5,460 (of 7,429 total)