Viewing 15 posts - 811 through 825 (of 1,222 total)
Have a look at [msdb].[dbo].[backupset] - it has a record for each backup
April 15, 2009 at 9:35 pm
db_datawriter won't be enough. This is the equivalent of GRANT UPDATE, INSERT, DELETE on every table to the user. It will not allow creation of triggers etc
I am...
April 15, 2009 at 9:34 pm
Log shipping itself will work. However, I am not sure Sharepoint will be able to use the database on the secondary server since SQL Server instance names are likely...
April 6, 2009 at 11:15 pm
The error you are getting suggests that you should be checking whether the SELECT statement returns anything before you try to use it (in your msgbox)....
Been a while since I...
April 6, 2009 at 11:13 pm
Database mirroring would be a good choice EXCEPT that your target is SQL 2008 and your source is SQL 2005. You can't mirror between versions of SQL Server because...
March 29, 2009 at 8:38 pm
Unfortunately, the IIF statement is not as elegant as you would like. The syntax for it is quite similar to the syntax used by Excel...
IIF (Condition, result if true,...
March 29, 2009 at 5:59 am
There is no correct answer to this without knowing what queries are being used against the table. 10 indexes may be the correct number.
It really depends on...
March 29, 2009 at 5:46 am
A single statement will not update just some of the records that it would otherwise have updated if it were not cancelled, regardless of whether the sproc uses transactions. ...
March 29, 2009 at 5:41 am
I am not sure where you get your information from but ...
- running a SSIS package from SQL Agent will not affect database operations other than the potential use of...
March 29, 2009 at 5:36 am
The ALTER DATABASE commands that are used to change the role of each database do not require you to break or configure mirroring at all. You should not need...
March 22, 2009 at 9:54 pm
The problem you have is that the UPDATE function returns true if the column is mentioned in the INSERT or UPDATE statement that caused the trigger to fire regardless of...
March 19, 2009 at 8:38 pm
You cannot connect to a SQL 2005 instance using Enterprise Manager.
Normally, I would have the distributor as the server with the highest edition/Service pack level. This means that in...
March 9, 2009 at 9:23 pm
The integer key is but one implementation of how to get good performance. For tables that are not subject to update activity will still benefit from this strategy (or...
March 5, 2009 at 4:10 am
For SQL Server, the general rule is to have a small montonically increasing column as the (unique) clustering key for the table - most people choose from one of...
March 4, 2009 at 8:24 pm
First - I am not a windows expert - I know what happens although some of the terminology on the Windows side might a a little wrong. So...
Windows has...
February 26, 2009 at 7:49 pm
Viewing 15 posts - 811 through 825 (of 1,222 total)