Viewing 15 posts - 29,566 through 29,580 (of 39,771 total)
If you look by the bottom post there's a drop down with post options. You can choose to apply settings to one or more posts. Not sure how useful this...
February 11, 2008 at 3:15 pm
Shouldn't be any repearrs. There are some similar ones, but not repeats.
February 11, 2008 at 2:27 pm
Please try these feeds for the Zune:
http://feeds.feedburner.com/ SqlservercentralcomWmv
http://feeds.feedburner.com/SqlservercentralcomArticlesTaggedEditorial-Mp3
February 10, 2008 at 4:18 pm
Did you add the new user as a login to SQL Server? By default, administrators have rights to log into SQL Server.
February 10, 2008 at 9:13 am
I believe that list is populated from sys.databases, so if it's in there, it should be there.
However it's possible there's some ownership problem. Who owns the new database?
The image doesn't...
February 10, 2008 at 9:12 am
sp_help_revlogin is a script that can create a script for logins from the old server.
February 10, 2008 at 9:09 am
This sounds like homework. Please show some effort in creating a trigger and using basic logic. This isn't that hard and we'll help point you in the right direction, but...
February 10, 2008 at 9:07 am
If it's that important, call PSS. They'll walk you through the process.
February 10, 2008 at 9:06 am
What did you do when you created the database. running the script does not necessarily add data to your tables unless there were insert statements in your script.
Look through the...
February 10, 2008 at 9:04 am
I'd agree with the above advice in general. DTS or SSIS could be used, or a simple script in a job. However maintenance plans work great.
February 10, 2008 at 9:02 am
How much is your data growing by? 75GB isn't that much and it's good to keep free space in there. It's used during index rebuilds, data growth, etc.
As Gail mentioned,...
February 10, 2008 at 9:00 am
Is there a reason why you're concerned about this?
February 10, 2008 at 8:58 am
They can be different from vendor to vendor, so you might need to go to their training.
However I'd start by buying a cup of coffee or a box of doughnuts...
February 10, 2008 at 8:57 am
You need to stream this out with ADO. It doesn't need to be C# code, simple VBScript or Powershell could help here.
http://support.microsoft.com/kb/258038
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7354
http://andrewu.co.uk/clj/load_and_save_file_helper_functions/
February 8, 2008 at 10:13 am
you can call system functions in the trigger (suser_sname(), user user_name()) to find out which account is used.
February 8, 2008 at 8:29 am
Viewing 15 posts - 29,566 through 29,580 (of 39,771 total)