Viewing 15 posts - 1,321 through 1,335 (of 1,584 total)
It doesn't matter. I use a program from sysinternals and in order to get that to run I had to first manually run it from the command line and...
November 18, 2011 at 8:56 am
Check the default SQL Server trace file (in your SQL Server's default installation directory, in the LOG folder), all DDL's are tracked there.
November 18, 2011 at 8:52 am
When you first ran the robocopy, were you prompted with anything like "this is freeware, click OK..." or "please register", or something else (anything that resulted in a pop-up box?
If...
November 18, 2011 at 8:46 am
Have you tried this link?
November 17, 2011 at 2:50 pm
This site definitely needs a few options for the forums..."Question Resolved" and "Remove Post" would be ideal š
Did you get your email issue all fixed up in the other post?
November 17, 2011 at 2:44 pm
It's actually a lot simpler than you think:
SELECT Col1, Col2, Col3...
FROM dbo.MyTable
WHERE DATEPART(hh, Col1) = 12
Just need to remember that in my example, the "hh" is looking at the hours...
November 17, 2011 at 2:41 pm
I've always been curious about which value should be set as a fillfactor and why as well...clearly there's different reasons for it when it's a clustered or non-clustered index, or...
November 17, 2011 at 2:29 pm
When you set your @LServer variable wrap it within square brackets. This gets rid of the issues with linked server names like 'abc-server'. The result will be [abc-server]...
November 17, 2011 at 2:22 pm
Yes please post the code...
Also, do you have your proxy account set up for your SQL Server Agent Service Account? I'm pretty sure that it acts the same was...
November 17, 2011 at 2:14 pm
SET BAN_READUNCOMMITTED = ON
= Awesome
November 16, 2011 at 10:04 am
I think what DEV meant was he's a victim of inheriting the practice from others. I dont' think any one on this forum would say its usage is considered...
November 16, 2011 at 9:38 am
I read that DEV, but was responding to your current backup plan and logicinside22's backup plan suggestions.
I'm wondering if Iām missing anything when it comes to backing up my database?
The...
November 16, 2011 at 9:30 am
You should be able to create and SSIS job that utilizes a FOR EACH container so you can loop through the list of SQL tables. Of course, you'll need...
November 16, 2011 at 9:20 am
Transaction Log Backup - every 15 min or 30 min.
Differential backup -Every night
FUll backup - once in a week .
system backup - once in week or you can do...
November 16, 2011 at 9:15 am
While I'm not 100% certain Ibelieve this to be a communication issue between the SQL OLEDB and the OLEDB 12.0 drivers.
You'll need a "Data Connectivity Components" update, available at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734...
November 15, 2011 at 1:47 pm
Viewing 15 posts - 1,321 through 1,335 (of 1,584 total)