Viewing 15 posts - 3,046 through 3,060 (of 6,679 total)
laddu4700 (8/1/2011)
I am not sure whether I can ask a general question here, sorry I am posting in wrong place.
Who will write the end-user report scripts ( business logic based)....
August 1, 2011 at 8:38 pm
I am not sure I followed your different options - but, if you are looking at creating a new instance of SQL Server on a new system then that system...
August 1, 2011 at 2:39 pm
Make sure the service account running SQL Server has access to the network share, then use the UNC path to access the backup files.
Be aware that backing up or restoring...
July 31, 2011 at 9:00 pm
Users are stored in the database (see: sys.database_principals). With that said, if you make sure the logins are recreated with the same SID on the new server - when...
July 30, 2011 at 10:00 am
brent.kraus (7/29/2011)
TheSQLGuru (7/12/2011)
Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.Completely agree! Ola's maintenance scripts are very valuable!
And exactly...
July 29, 2011 at 4:34 pm
In your situation, I would recommend that you not do it this way.
Instead, build the new VM with Windows Server 2008 R2 - then, install SQL Server 2005 on the...
July 29, 2011 at 1:46 pm
The real question here is why are you managing your log files by shrinking them. You should have frequently scheduled (every 15 minutes is a good start) transaction log...
July 29, 2011 at 1:38 pm
Ninja's_RGR'us (7/29/2011)
The difference is that you can reuse the cte without having to retype it in the query. But that now runs 2 twice.
I just wanted to point out...
July 29, 2011 at 1:34 pm
Do you have a query window open with a connection to that server?
Gus has asked this multiple times, and you still have not answered that question.
Do you have the client...
July 26, 2011 at 9:07 pm
What is the client version on the client desktops that is working? It sounds to me like those are not the same version - probably been updated to a...
July 25, 2011 at 9:18 am
Check the server version you are connecting to and the client tools version. You probably are using client tools that have not been updated to at least the same...
July 24, 2011 at 8:25 am
When you say copy - do you really mean backup? It isn't clear what you are referencing...
If you are having performance or network issues trying to backup across the...
July 22, 2011 at 11:40 am
I would look into any of the monitoring tools from the following companies:
Quest
BMC (Patrol)
CompuWare (ServerVantage)
CA
All of these companies provide monitoring tools for SQL Server, Oracle and the OS.
The tools include...
July 19, 2011 at 8:18 pm
What version is the server you are connecting to - and what is the version of the client tools you are using.
You need to be on 9.00.3054 at a minimum...
July 19, 2011 at 2:37 pm
Okay, first - remove the shrink. It should never be a scheduled operation.
Second, since you are probably rebuilding all indexes - change the update statistics step to only update...
July 19, 2011 at 2:35 pm
Viewing 15 posts - 3,046 through 3,060 (of 6,679 total)