Viewing 15 posts - 1,321 through 1,335 (of 1,583 total)
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.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 18, 2011 at 8:46 am
Have you tried this link?
http://support.microsoft.com/kb/925744
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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]...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 17, 2011 at 2:14 pm
SET BAN_READUNCOMMITTED = ON
= Awesome
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2011 at 1:47 pm
hi everyone,as im new to sql server i would like you to help me with the stored procedures.
the requirement is to get the data in the dropdownlist.
i have a table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2011 at 1:39 pm
Viewing 15 posts - 1,321 through 1,335 (of 1,583 total)