Viewing 15 posts - 2,911 through 2,925 (of 6,676 total)
You need the password. It is a domain account and you cannot change it without affecting the other system.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 13, 2011 at 8:50 pm
First, you need to add your account to SQL Server and set it up as sysadmin. Then, you can remove the sysadmin right from BUILTIN\Administrators.
Right now, you are authenticated...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 13, 2011 at 7:25 pm
Perry Whittle (12/13/2011)
Chrissy321 (12/13/2011)
I have xp_cmdshell available on this serverNo xp_cmdshell, just execute the vb script from a SQL server agent job step
Or - look at creating a Powershell script...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 13, 2011 at 7:18 pm
Tristan Chiappisi (12/13/2011)
You guys are getting side tracked! 🙂Let me rephrase the question:
Has anyone used a parallel network file moving software that they would recommend?
Thanks!
-Tristan
We purchase a product called RocketStream...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 13, 2011 at 6:59 pm
Barkingdog (12/12/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2011 at 6:47 pm
Nobody has mentioned this option - which I believe is exactly what it was designed for.
Lookup Service Broker in Books Online. Using a service broker, the broker will be...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 11, 2011 at 9:31 am
Create a group level in the report and group on the data that you want in your single row. Leave out the data that is causing the duplicate rows.
If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2011 at 3:36 pm
Select log_reuse_wait_desc From sys.databases
Using the above, that database will probably show REPLICATION. Is this database replicated - and if it is have you verified the replication is working?
If it...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2011 at 3:34 pm
Here is what I would do...
Set a max size on each tempdb file so you don't exceed 100GB - since you say it normally doesn't grow much. Then, wait...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2011 at 11:53 am
MidBar (12/6/2011)
OR
can be any dis-advantage if we write like 23/sep/2011 111213?
"YYYY-MM-DD HH:MM:SS...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 6, 2011 at 12:30 pm
It looks like you either have a database named with a space - or, your script is returning a row with a space for a database.
Really would need to see...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2011 at 5:43 pm
mphilippopoulos (12/5/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2011 at 5:33 pm
If you have Visual Studio - you probably have the dumpbin utility. You can use that - and then search the output for the machine.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2011 at 12:38 pm
ashanair70 (12/4/2011)
If there is a need to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2011 at 12:14 pm
Michael Valentine Jones (12/3/2011)
Jeffrey Williams 3188 (12/2/2011)
Select dateadd(month, datediff(month, -1, cast(@year as char(4)) + '-' + cast(@month as varchar(2)) + '-01'), -1)
That code is sensitive to the setting of DATEFORMAT....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 4, 2011 at 7:01 am
Viewing 15 posts - 2,911 through 2,925 (of 6,676 total)