Viewing 15 posts - 361 through 375 (of 1,222 total)
You can rename or move the errorlog.n files pretty much as you please. As far as SQL Server is concerned, the current errorlog file is important. The rest...
April 1, 2013 at 9:11 pm
I think you will find that the problem really is that diagram are created in the table sysdiagrams. Unless the customer copied the data in this table from the...
March 14, 2013 at 8:32 pm
Coincidentally, I had a similar problem just this morning with a sproc that calls msdb.dbo.sp_help_job
Have a look at http://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-error
In particular, the syntax used in the first workaround. The part...
March 13, 2013 at 9:17 pm
Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading to match what...
March 5, 2013 at 8:26 pm
Yes - you will need to restart the distribution agent.
March 5, 2013 at 8:18 pm
You are running AS as the "NETWORK SERVICE" account and this does not, currently, have permission to acces the Proj Svr database.
You have a few options
- change the connection...
February 28, 2013 at 7:58 pm
I can't help with info about a product that will make the SSRS sites "look" like one site
As far as report security is concerned, you can secure items within a...
February 28, 2013 at 7:51 pm
Have a look at the properties of the text box that contains the dealer name - there should be a property called "Indent" (not sure which versions of SSRS this...
February 27, 2013 at 8:01 pm
have a read of http://msdn.microsoft.com/en-us/library/tcbchxcb(v=VS.80).aspx - has info on the implications of "SET TRANSACTION ISOLATION LEVEL SNAPSHOT".
As for the way that replication handle transactions, launch Replication Monitor and change the...
February 21, 2013 at 9:01 pm
I am not sure but I suspect that the distributor you are using is SQL 2008 R2. Normally, I would expect the distributor to be the most recent version...
February 21, 2013 at 8:53 pm
I am not sure that mirroring will be a viable option if you are needing to mirror 500 databases. MS publish a document on the server resources required (http://support.microsoft.com/kb/2001270)....
February 21, 2013 at 8:50 pm
Have a look at [sys].[dm_db_index_usage_stats] - it has info about scans and might be what you are after. You will need to join to sys.objects and sys.indexes to get...
February 21, 2013 at 8:28 pm
Snapshot isolation level may be able to help but it does require some changes - either the properties set for the connection need to be changed or the t-sql code...
February 18, 2013 at 7:56 pm
You can restore a backup to a more recent version of SQL but you CANNOT go the other way. This means that any backup done on your secondary (SQL...
February 17, 2013 at 8:20 pm
Viewing 15 posts - 361 through 375 (of 1,222 total)