Viewing 11 posts - 31 through 41 (of 41 total)
December 17, 2008 at 1:48 am
http://support.microsoft.com/kb/203638
James Howard
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...
James Howard
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.
James Howard
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...
http://msdn.microsoft.com/en-us/library/ms161956.aspx
James Howard
December 15, 2008 at 7:20 am
RAID is useful for fault tolerance.
James Howard
December 15, 2008 at 6:18 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...
James Howard
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...
James Howard
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...
James Howard
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...
James Howard
December 15, 2008 at 2:42 am
Viewing 11 posts - 31 through 41 (of 41 total)