I am pretty sure that I am going to have to call MS Support on this issue, so I thought I would bounce it off of ya'll first and get my thoughts in...
Can anyone give me a good quick lesson on how this is achieved?<br /><br />I have read<a target="_blank"...
We currently have a 2 node 3 instance cluster that is affectionately known as SQL1SQL1, SQL2SQL2 and SQL3SQL3.<br /><br />We are about to start...
Hey everyone, I have a database .mdf file that has grown to 26GB, 18GB of that is unused space. I made a backup of the database and restored it to...
Is there a way to change the retention period of the job history that is kept in msdb.dbo.sysjobhistory? Currently it appears as though about 2 days...
I am wondering if anyone else here as seen this behavior, or if I am missing a KB article about this situation. I have a 2 node activeactive cluster...
I have a question for you all... I am trying to execute a stored procedure within another stored procedure and use one column from the result set...
of course... who doesn't Situation: same query, same data, same indexes on three instances... test instance... Dell Poweredge 4400 - 2 860 Mhz...
Hi everyone,<br /><br />We are having a large number of deadlocks from a certain application that is written in java. I have tried running a...
on a 32 bit system with 2000 x64?<br /><br />Any idea if it will work as nice as 2005 is supposed to?<br /><br />BTW, if you haven't watched this......
Here is the situation, my organization has decided that they want to keep tabs on what people are doing on the databases, I know that one way to do...
What I am trying to accomplish would be to have a job that ran every week or so that scripted out 4 databases on one of our cluster instances. I...
HELP!!<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />DB size.. 3,137,920 KB<br />Log Size.. 6,759,424 KB<br /><br...
I want to log all users who change their passwords, not necessarily the PW that they change from or to, just the fact that the sql user pw changes....
I have a data warehouse that holds data that is moved from DB2 on the mainframe to SQL Server nightly. This data is read only and thus the only...
Hello, I work for a large organization that stores a large amount of data in DB2 on an OS390 mainframe, all of the daily transactions are stored...
Separate names with a comma.
