Viewing 15 posts - 2,491 through 2,505 (of 7,168 total)
To view all default trace files:
Reviewing AutoGrow events from the default trace by Aaron Bertrand
January 8, 2013 at 7:50 am
It sounds like you're referring to msdb.dbo.sp_start_job which returns control to the caller immediately after submitting the request to SQL Agent to start the job reporting 1 or 0 as...
January 7, 2013 at 3:47 pm
Minaz Amin (1/7/2013)
Hi All,We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?
No. You only designate one partition...
January 7, 2013 at 3:30 pm
The reference to dbo.SORT in the error message says to me that the growth was due to an internal work table that spilled to tempdb. Some reasons why this could...
January 7, 2013 at 3:20 pm
I am pretty sure it is based on how the transactions are committed to the log, per the Log Reader Agent traversing the log. Otherwise there could be all sorts...
January 7, 2013 at 3:12 pm
sql_er (1/7/2013)
Group 2: Needs to be able to do anything within the database (dbo)
Membership in the db_owner Role (could be many members) is not the same as the dbo user....
January 7, 2013 at 2:35 pm
It is likely something to do with the User-defined Type not being present locally. Even though I have dbo.SampleDataType defined locally defined the same as the remote server I still...
January 7, 2013 at 2:12 pm
manibad (1/7/2013)
1.In data flow task,OLE DB source->Sort->Data conversion->Excel destination(target is Format.xlsx(template file))
2.In file system task,Source path is Format.xlsx(template) and destination file...
January 7, 2013 at 11:22 am
The formatting will be pre-set in the "template" file. Open your "template" in Excel, adjust the formatting so it appears as you would like (e.g. bold column headers, background colors,...
January 7, 2013 at 10:43 am
parvathaneni.vijay (1/7/2013)
January 7, 2013 at 8:55 am
It's possible something with the OLE DB driver could not infer (or the database did not return an acceptable inference) the data types output by the expressions making up the...
January 7, 2013 at 8:02 am
Bhuvnesh (1/6/2013)
certainly , we can have trigger (instead of) but i will suggest to set the trigger on table.
That likely will not help the situation. There is unique value added...
January 6, 2013 at 11:53 am
Evil Kraig F (1/3/2013)
January 5, 2013 at 4:59 pm
There are a lot of moving parts within your request, and it will involve more than just a single script or technology. It sounds like you would be better off...
January 5, 2013 at 4:21 pm
I just installed the pre-release version of IE 10 on my 32-bit Windows 7 laptop and it exhibits the same behavior as IE 10 on my Surface RT...no My Posts...
January 5, 2013 at 4:05 pm
Viewing 15 posts - 2,491 through 2,505 (of 7,168 total)