Viewing 15 posts - 2,821 through 2,835 (of 3,738 total)
master.dbo (6/23/2011)
george sibbald (6/23/2011)
We don't have any SSIS packages on this server.
I do have maintenance plans.
My main concern is making sure the users and sql agent jobs are moved...
June 23, 2011 at 9:35 am
Have you read the sql server Setup Log Files?
June 23, 2011 at 9:12 am
You should use the configuration manager.
June 22, 2011 at 7:48 pm
sysadmin will work but it will assign excessive permissions. 🙂
June 22, 2011 at 7:08 pm
Have you configuered Database Mail?
June 22, 2011 at 5:55 pm
Refer to Converting a Nonpartitioned Table to a Partitioned Table at the following URL:
http://sqlserverpedia.com/wiki/Indexing_for_Partitioned_Tables
June 22, 2011 at 4:27 pm
Jayanth_Kurup (6/21/2011)
Would it be acceptable to store the details as belowUsername,
password ,
Lastloggedin,
usertype,
XML_userspecificdata
What is stored in the XML Data?
June 22, 2011 at 12:14 pm
laddu4700 (6/20/2011)
Yes, I meant taking print -hard copy of db diagram
also any idea of third party tools to create a db diagram
Can't you print yor ERD in Visio?
If you have...
June 22, 2011 at 12:09 pm
Robert Magrogan (6/20/2011)
June 22, 2011 at 12:01 pm
Robert Magrogan (6/20/2011)
The following script can be used to add the TIME STAMP column to one table at a time.
ALTER...
June 22, 2011 at 11:54 am
Agreed, I usually use the "go to the store and find some answers" method before making a purchase.
June 20, 2011 at 7:18 am
I have the 2K Book as well.
Here is the link to the book (US):
http://www.amazon.com/Professional-Microsoft-Server-Programming-Programmer/dp/0470257024
http://www.amazon.com/Professional-Microsoft-Server-Programming-Programmer/dp/0470257024
June 20, 2011 at 6:12 am
What column is the primary key?
June 20, 2011 at 6:09 am
Viewing 15 posts - 2,821 through 2,835 (of 3,738 total)