Viewing 15 posts - 5,206 through 5,220 (of 6,678 total)
Alvin Ramard (5/11/2009)
Grant Fritchey (5/11/2009)
Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.Suffice to say. I'm done.
Someone...
May 11, 2009 at 2:28 pm
For each database, you could do the following:
GRANT UPDATE ON SCHEMA::dbo TO {user/role};
Assuming the schema you want to grant update privileges to is 'dbo'. If not, change the schema...
May 11, 2009 at 2:25 pm
Shawn Therrien (5/11/2009)
I do apologize. I didn't realize that VPN software didn't work with a 64bit OS and was stranded away from my work materials.
Not sure what VPN software you...
May 11, 2009 at 2:17 pm
The property you are trying to get to does not exist. Use $srv.VersionMajor instead of $srv.Information.MajorVersion.
May 11, 2009 at 2:10 pm
If you need to do something like this with any frequency - I would suggest that you invest in the great tools from our sponsors. SQL Compare and SQL...
May 10, 2009 at 2:42 pm
Right - so, to get around the issue with the view designer - open a new query window and write the create statement yourself. You won't get the error...
May 8, 2009 at 8:04 pm
Did you try creating the view by issuing the CREATE VIEW statement? Or are you using the view designer?
Also, you should know that the TOP (100) PERCENT and ORDER...
May 8, 2009 at 5:23 pm
If you really cannot use dynamic SQL - the other options are to force the stored procedure to recompile each time it is called, or you can force the statement...
May 8, 2009 at 5:18 pm
Steve Park (5/7/2009)
May 7, 2009 at 2:29 pm
Setting the retention period for the backup does not remove old backups. To actually remove old backup files you need to add the maintenance cleanup task and configure it...
May 7, 2009 at 2:18 pm
When those databases were removed, was the maintenance plan modified to remove the old databases?
May 7, 2009 at 2:13 pm
AFAIK - that option was made available in SQL Server 2005 when using the ALTER INDEX syntax. It is not available, even in 2005 using DBREINDEX.
May 7, 2009 at 2:08 pm
How are you being notified that the recovery model has changed? Do your backups start failing 'all of a sudden'?
If the following command is executed, then you will not...
May 7, 2009 at 1:42 pm
The min setting here is less important than the max setting. Without setting the max memory - both instances are trying to use memory that the other instance is...
May 7, 2009 at 1:36 pm
As others have stated - no it is not possible. The real question is what problem are you trying to resolve? What data exists in tempdb that you...
May 7, 2009 at 1:31 pm
Viewing 15 posts - 5,206 through 5,220 (of 6,678 total)