hi, just a quick question with this replication jobs from replication monitor you can schedule to run anytime you want just as any other job?

hello with your script i get the error:

Procedure or function 'sp_dumplog' expects parameter '@dmpdevice', which was not supplied.

Thank you!:-)

thank you all for your input, i am trying to do this because i was having issues with a stored procedure with parameter sniffing. I solved the problem by...

hi thank you guys

i am trying to execute this

dbcc freeproccache (0x050007002D47DA3D4063236D020000000000000000000000)

but i get this error:

Msg 2583, Level 16, State 3, Line 1

An incorrect number of parameters was given...

ok after doing some research i found out my indexes that start with _dta_index are "hypothetical indexes" meaning they are not real indexes only recommendations from the DTA, so should...

hello, i ran the script in the link I mentioned above:

http://www.mssqltips.com/tipimages/1003_sp_helpindex3.txt

-- Modified sp_helpindex SP to show all indexes for all tables

-- this was modified to handle object owned by...

I use a modification of sp_helpindex

I found in this site:

http://www.mssqltips.com/tipimages/1003_sp_helpindex3.txt

thank you!

thanks for your input guys, so if i do it with batches, let 's say 10000 at a time, would it also help to create a temp table and then...

hello, thanks for you reply, it looks like the server won't let me unless i change the configuration of the adhoc queries. :crazy:, since is a production server I can't...

i am running it on my DB , is called Distributors

DBCC opentran(Distributors).

Thank you so much guys! i did the detach, added the file extensions and attached again and everything is ok now. I was wondering how this could had happened...

it is unchecked, also for my other Dbs, the extension do show correctly except for this one. .. :crying:

For all my mdf, ndf, ldf files, I have Type: FILE

they don't have file extensions in the names example: DBA_Files instead of DBA_Files.mdf, etc...

when i double click the...