Viewing 15 posts - 166 through 180 (of 14,953 total)
majorbloodnock (1/15/2013)
Gary Varga (1/15/2013)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2013 at 6:35 am
It's not a link. In Windows, open the Start Menu, and type Windows Update. The top item that the search finds will (normally) be "Windows Update". Click...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 3:07 pm
Actually, your best bet for that is replaying a trace file from the current server on the new server. Details on how to do that are here: http://msdn.microsoft.com/en-us/library/ms189604(v=sql.105).aspx
Collect the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 3:04 pm
All that means is you have an out-of-date copy of Windows 7.
Assuming it's a legal copy, you can use Windows Update to get SP1, and then you'll be fine. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 3:01 pm
sp_cursorprepexec is a built-in stored procedure that comes with SQL Server. Details here: http://msdn.microsoft.com/en-us/library/ff848775.aspx
But it looks like it's in a comment-block in the code you quoted. /* begins...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 2:59 pm
What edition of SQL Server 2012? Enterprise? Standard? Express? Developer?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 2:50 pm
Beginner_2008 (1/10/2013)
Can anybody suggest a good third party software?I was trying t go with redgate. ANy advise please.
RedGate SQL Backup is a good product. Not sure what that has...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 2:50 pm
Well, it'll probably look something like this:
DELETE FROM dbo.MyTable
WHERE MyDateColumn >= '2012-06-01' AND MyDateColumn < '2013-01-01';
SQL Server will log every row row deleted. Has to in order to maintain...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 2:48 pm
Definitely not. That was an old practice in prior versions of SQL Server, and Microsoft moved away from it in SQL 2005 and recommended against it. Use schemas...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 1:35 pm
Can I call this proc recursive? Under the headings of Performance, it shows some problems coming up from proc sp_Blitz. 🙂
[master].[dbo].[sp_Blitz] has WITH RECOMPILE in the stored procedure code,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 12:53 pm
How you record the changes is pretty key to how you report them, but not necessarily critical.
If you want to regularly query the data, then you either need "active auditing"...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 12:35 pm
Sounds like you're off to a good start.
A couple of things you can do:
Right-click a database in SSMS (Management Studio), then Report -> Standard Reports -> Backup and Restore Events....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 12:28 pm
Advice about it? Read the documentation and ask the questions that come to mind. I found it pretty straightforward once I just followed the directions on MSDN, the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 12:19 pm
Danzz (1/9/2013)
Thanks for your replay GSquared 🙂Trying to insert the statement "Use Database" into a temp table?
Per your post immediately prior to my question:
create table ##permission_info (id int primary...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 10:12 am
That's when those databases were created. By Microsoft. Not by you.
Copy a database from one server to another, and you still get the data it was created on...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2013 at 12:21 pm
Viewing 15 posts - 166 through 180 (of 14,953 total)