Viewing 15 posts - 3,826 through 3,840 (of 6,676 total)
George,
I can see how that might be an issue - if that is option is enabled. However, if you have enabled that option - then you obviously 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
May 14, 2010 at 4:18 pm
mbrey (5/14/2010)
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
May 14, 2010 at 3:54 pm
mbrey (5/14/2010)
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
May 14, 2010 at 3:11 pm
george sibbald (5/14/2010)
Having the db owned by an ID that restored it is not in...
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
May 14, 2010 at 2:58 pm
Just for clarity sake - SSRS also has a mode where you can develop reports that are called by your application and run on the client system. This mode...
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
May 14, 2010 at 2:07 pm
You really should not be shrinking your database at all - because, as you are aware - it just grows again. The additional growth is expensive and will cause...
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
May 13, 2010 at 8:39 pm
lmu92 (5/12/2010)
Once that person "designed" a query he/she wants to run in production, that person should send the query to one of...
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
May 12, 2010 at 6:40 pm
I know this is for 2000 - but schema qualifying all objects is a recommended practice on SQL Server 2005/2008. There is an issue with not schema qualifying the...
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
May 12, 2010 at 1:50 pm
nikhil.desai1 (5/11/2010)
If we don;t have any backup taken than how to get the original data back.
If you are just looking for a way to be safe, and not actually trying...
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
May 11, 2010 at 1:49 pm
I have seen this in both 2005/2008 when you try and deploy a new report over an existing report. If the report has a different signature (GUID - I...
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
May 11, 2010 at 7:08 am
No need to even loop through all objects in the database. You can grant view definition to all objects in a schema in a single command:
GRANT VIEW DEFINITION ON...
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
May 10, 2010 at 9:34 pm
Okay, each login to SQL Server has to be defined. Windows logins can be added individually or through group membership. When you run SSIS packages from SQL Server...
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
May 10, 2010 at 9:02 pm
Jeff Moden (5/9/2010)
Jeffrey Williams-493691 (5/9/2010)
I don't see any reason to worry about which rows you have updated and/or tracking that in the temp table.
Keeps the locking localized to just a...
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
May 9, 2010 at 10:16 pm
I think you're over thinking this a bit - if I am understanding the relationship correctly. Since the ID's in both tables match, you really don't need to track...
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
May 9, 2010 at 9:56 pm
brutsoft (5/9/2010)
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
May 9, 2010 at 9:42 pm
Viewing 15 posts - 3,826 through 3,840 (of 6,676 total)