Viewing 11 posts - 31 through 41 (of 41 total)
Remote connections:
http://blogs.msdn.com/sql_protocols/archive/2005/11/14/492616.aspx
December 17, 2008 at 1:48 am
December 16, 2008 at 10:02 am
December 16, 2008 at 3:50 am
Books online has everything you need to know. I only buy books for specific areas that I need and for this I have found the inside microsoft sql server 2005...
December 15, 2008 at 1:03 pm
When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned.
December 15, 2008 at 8:56 am
You will find it at start>Microsoft SQL Server 2005>Configuration tools.
This link should help with your understanding...
December 15, 2008 at 7:20 am
Oh I see...
The sp_helprotect procedure (http://msdn.microsoft.com/en-us/library/ms190310.aspx) returns a field named grantor which identifies the name of the principal that granted permissions.
Hope that helps...
December 15, 2008 at 5:36 am
The following script will produce a list of all the defined permissions in the SQL Server database, linking the role with the role members and displaying their...
December 15, 2008 at 4:25 am
To transfer logins and passwords between two instances of SQL Server 2000, you can use the DTS Package Transfer Logins Task in SQL Server 2000. For details, have a look...
December 15, 2008 at 3:07 am
You can back it up but the purpose would be for its structure rather than its data.
Here is a link to some guidelines, including some of the other backup considerations...
December 15, 2008 at 2:42 am
Viewing 11 posts - 31 through 41 (of 41 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy