Viewing 15 posts - 13,261 through 13,275 (of 49,552 total)
What does the procedure proce_Name do?
btw, I strongly recommend against any architecture or design that has pieces of queries being passed around as parameters, it gets hugely complex, there are...
May 4, 2013 at 3:30 am
Possible, yes. Whether it's a good idea or not is another matter.
What happens if that's a long-running data import. Job automatically kills it after 2 hours, job rolls back for...
May 3, 2013 at 1:54 pm
I'll call BS on that. Changing the max memory setting is not going to affect SQL writes.
Could be that you have bad plans getting into cache (maybe problematic plan caching),...
May 3, 2013 at 1:52 pm
OnlyOneRJ (5/3/2013)
I think due to the Drive full & continues DML transaction on that DB.. the File must hacve corrupted..
Full log will send the DB read only, not corrupt the...
May 3, 2013 at 10:50 am
Can't figure out from your description what the exact situation is and what the specific problem is.
What happened (exactly, not vaguely)?
What is the current situation (specifics)?
What is the exact problem...
May 3, 2013 at 10:16 am
Lynn Pettis (5/3/2013)
What version (edition) of SQL Server ar you currently using?
Express. Was stated earlier.
May 3, 2013 at 9:37 am
IT researcher (5/3/2013)
Whether any other tweaks available which can help me to remove replication related data from it?
It's not that there's replicated data, there's replication markers left in the...
May 3, 2013 at 9:34 am
IT researcher (5/3/2013)
So is...
May 3, 2013 at 5:08 am
They should be near-identical in time (and bear in mind that SQL's timers aren't accurate down to the ms level, that's stats time and perfmon). While the second does do...
May 3, 2013 at 3:38 am
Not an open transaction (and detaching and attaching would never solve that, detaching and attaching a database won't change anything within the database)
Either the database has had replication in the...
May 3, 2013 at 3:24 am
Lowell (5/2/2013)
May 2, 2013 at 6:40 am
Varchar(N) for N 1..8000 can be stored 'in-page', that means with the rest of the row. Over that, it has to be stored in a list of LOB pages (each...
May 2, 2013 at 6:37 am
Encryption doesn't stop you from seeing the data, just that you'll see binary values (0xA45B2DF999212...) rather than something you can understand
May 2, 2013 at 4:27 am
http://msdn.microsoft.com/en-us/library/aa197950%28v=sql.80%29.aspx
Script out your jobs first, all logins, backup history, DTS packages, linked servers, server-level permissions. Since you have no backups, there's no other solution here, that corruption's not repairable.
Afterwards check...
May 2, 2013 at 4:26 am
Viewing 15 posts - 13,261 through 13,275 (of 49,552 total)