Viewing 15 posts - 31 through 45 (of 528 total)
Lynn,
The user id in question is SQL Server only, so your points are very useful indeed! Of course, it would be too easy to be allowed to simply 'force'...
September 20, 2011 at 9:41 am
There is only a single user other than 'sa', so it is both a single user and all of them....
the 'report' returns null set.
However, for our next test, I've added...
September 16, 2011 at 4:06 pm
Assumptions to verify for the cloud:
1. The security environment is suitable
2. SLA is ironclad and something you can live with
3. Response time performance to inquiries and issue...
September 15, 2011 at 9:11 am
@dcs.. - why did you choose the parameter setting '101'? Look up the command (Books OnLine [BOL], or brute force via Google) and make certain you understand your date...
September 15, 2011 at 8:59 am
Gail and James,
Thank you for the debate! I was wondering about taking a second backup on the log file...I think i remember that being mentioned before somewhen on these...
July 8, 2011 at 4:10 pm
While not free, BackupAssist is reasonably priced, very straightforward, and works well with Windows products. As noted above, this is no substitute for setting up regularly scheduled backups for...
July 5, 2011 at 10:03 am
Arthur.Lorenzini (5/3/2011)
May 5, 2011 at 2:13 pm
I intend to use SQL Agent processing to test the actual scripts just to confirm that, as written, the commands do what I want.
I also need to experiment with the...
April 13, 2011 at 8:11 am
Well, I'm happy to report that I have managed to get the bcp command to properly execute. I've even managed to experiment with the '.\..\.....' prefixing to correctly point the...
April 12, 2011 at 1:14 pm
The sql query is written and works. To accommodate the limitations of bcp performing only a single select, I took my memory table and made it a permanent lookup...
April 8, 2011 at 3:26 pm
Well, I finally figured out that bcp is an .exe requiring a command window. However, I want to specify an input file rather than enter the query, because the...
April 8, 2011 at 2:40 pm
I apologize for the confusion. Let's try this: SS 2008 SE database TABLE aggregates system logs from multiple servers for multiple 'customers'. The requirement is to produce,...
April 8, 2011 at 1:03 pm
BCP would be an excellent solution IF I knew the output file format. Where will I find the definition(s) for truncation that SSMS provides? When I examine an...
April 8, 2011 at 12:12 pm
Did you check the Windows 7 equivalent of add/remove programs to verify that no version of SQL Server 2008 R2 is listed for uninstall? If there are any SS2008R2...
April 8, 2011 at 8:30 am
Assumptions:
1. Currently both sides of mirror ARE synchronized.
2. Your desired primary is now the mirror because of an operating failure.
Solution:
1. Take your primary offline and fix the...
April 8, 2011 at 8:25 am
Viewing 15 posts - 31 through 45 (of 528 total)