Viewing 15 posts - 4,471 through 4,485 (of 7,164 total)
sqldba_newbie (4/16/2012)
opc.three (4/16/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 3:22 pm
Who were you logged in as when you ran KLIST PURGE? The same account as the SQL Server service account?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 3:19 pm
Not sure which order you were doing what, but for the record the SQL Server service will re-register an SPN if it has rights to Active Directory (LocalSystem, NETWORK SERVICE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 3:11 pm
EDIT: blah...site once again cross-posted a response to another thread for me
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 3:05 pm
I think the upgrade wizard does want to reach out to the server to validate and update any metadata necessary to make the upgrade a success. You can open all...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 2:01 pm
Yeah, I was just making sure you were comparing apples to apples and not looking at something like SQL:StmtCompleted vs SQL:BatchCompleted or RPC:Completed. Now that we have that cleared up,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 1:51 pm
George, You're a veteran. Why would you offer up a solution using a feature that has already been removed from the current version of the product?
From the article to which...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 1:39 pm
chewychewy (4/15/2012)
However for my case here all those privileges were granted during default installation. Do u think...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 1:33 pm
As mentioned you have to enable the CLR at the instance-level but you can enable it on the instance and add a DDL trigger FOR the DDL_ASSEMBLY_EVENTS event group in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 12:57 pm
Which readings in your OP go with which trace event?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 12:36 pm
I have not had good luck using the DTS Designer in SQL 2005. It was buggy and was a modal window (at least it used to be) so I resorted...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 12:31 pm
...and should not be used in new development.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 11:00 am
george sibbald (4/16/2012)
you can specify a password when you create a backup, which would then be required to restore from the backup file.http://msdn.microsoft.com/en-us/library/ms186865(v=sql.100).aspx
this option will not be present in SQL2012
The...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 10:43 am
- PGP (gnupg is a good, free option)
- Third-party backup tools like redgate SQL Backup[/url]
- TDE (requires Enterprise Edition) protects your data at rest using the SQL encryption hierarchy so...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 8:49 am
shiv-356842 (4/14/2012)
i want all logins and groups in a instance in sql server 2008 R2
can you please provide script for this
i can use sp_help logins, sys.syslogins,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 16, 2012 at 8:42 am
Viewing 15 posts - 4,471 through 4,485 (of 7,164 total)