Viewing 15 posts - 31 through 45 (of 144 total)
Grant Fritchey (3/7/2013)
How about taking a look at the system_health extended event session. It automatically captures...
March 7, 2013 at 11:19 am
Gazareth (3/7/2013)
Which error log? That sounds like a user error message rather than one you'd see in the sql error log.
In the SQL Server logs.
IT seems to be...
March 7, 2013 at 11:14 am
No, I am trying to restore to a new database name while the existing one stays in place.
I ended up having him restore the database to another server with the...
February 20, 2013 at 8:00 am
For the new user, I'd it to generate a create user statement:
USE [dbname]
GO
CREATE USER [mynewuser] FOR LOGIN [domain\firstname.lastname]
GO
Where mynewuser is paramater 1 and domain\firstname.lastname is second parameter.
December 13, 2012 at 9:10 am
Seems like it's working better as I'm getting output now.
But this error is coming up:
Msg 4145, Level 15, State 1, Line 35
An expression of non-boolean type specified in a context...
October 8, 2012 at 8:06 am
Sorry, somehow I got the steps mixed up, first is actually
Page locks = ON
then the reindex
then Page locks = OFF
The application requires this setting, otherwise it generates errors during...
October 5, 2012 at 11:43 am
Here's the command:
alter index [UQ__ICMUT012__130D42861D913A15] on [wpsdbJcr].[jcr_Sch].[ICMUT01279001] reorganize
Here's the error:
Msg 2552, Level 16, State 1, Line 1
The index "UQ__ICMUT012__130D42861D913A15" (partition 1) on table "ICMUT01279001" cannot be reorganized because page level...
October 5, 2012 at 8:05 am
I turn it off because I receive an error that it cannot reindex them with page lock on.
October 4, 2012 at 10:53 am
I think I see the problem, somehow the column name has extra spaces, so I just added rtrim in the charindex.
October 1, 2012 at 1:50 pm
I'm on SQL 2008:
When I exec I get:
Msg 102, Level 15, State 1, Line 35
Incorrect syntax near 'Schema_Name'.
Msg 102, Level 15, State 1, Line 37
Incorrect syntax near 'obje'.
October 1, 2012 at 11:48 am
I have changed
m.objectid to
cast( M.object_id as varchar)
September 28, 2012 at 7:43 am
I'm on SQL 2008. I am trying the script and getting an error:
Msg 245, Level 16, State 1, Line 7
Conversion failed when converting the varchar value ';
EXEC (@sql);
' to...
September 28, 2012 at 7:00 am
ok, I'll check the settings.
Yes, someone downloaded or named the file wrong and so we got a different format that it tried to import.
August 8, 2012 at 1:58 pm
Viewing 15 posts - 31 through 45 (of 144 total)