Viewing 15 posts - 3,271 through 3,285 (of 6,676 total)
Okay, I am a bit confused here. In your original post, you stated that SQL Server was granted 44GB of memory, then your latest states 48GB - but, 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
April 14, 2011 at 1:57 pm
Yes, it can but you should review the article from microsoft. I don't have the link for the article, but you should be able to find it through google.
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
April 14, 2011 at 1:00 pm
I would say, most definitely not...
The transaction log will contain a record of all transactions that have occurred - and also contains the information needed to rollback a transaction and/or...
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
April 14, 2011 at 12:49 pm
That indicates that you probably have not run the instcat.sql updates on the 2000 box. Again, this is required when creating a linked server from a 2005/2008 system 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
April 14, 2011 at 12:45 pm
Grant Fritchey (4/14/2011)
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
April 14, 2011 at 12:36 pm
Did you run instcat.sql on the SQL Server 2000 box? This is needed if you are creating a linked server from SQL Server 2005 or higher back to 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
April 14, 2011 at 12:31 pm
I don't know of any specific tutorials - there are some, you just have to google them. I mostly just have learned on my own and don't really do...
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
April 14, 2011 at 12:15 pm
When you configure the flat file connection - set it up so text columns are defined with double-quotes. That will tell SSIS to ignore embedded commas in the data.
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
April 13, 2011 at 8:55 pm
annasql (4/13/2011)
Thanks all.When you say you use GUI to change dbowner, how do you do that?
Thanks
Right-click on the database in Object Explorer or Object Explorer Details - select properties...
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
April 13, 2011 at 6:40 pm
Most likely the reason why this doesn't work is because of the way the procedure is written. If you are using a cursor and not using a straight SQL...
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
April 13, 2011 at 12:13 am
When you executed your stored procedure, I am guessing that you opened it (modify?) or scripted it to a query window. Then you clicked on the execute button or...
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
April 12, 2011 at 8:13 pm
Lookup SUBSTRING and CASE in books online, here is an example:
SELECT ...
,t.unit
,CASE substring(t.unit, 3,...
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
April 12, 2011 at 8:05 pm
Basically, I will either use the GUI - or I will use powershell, depending upon how many databases and what else is going on at the moment.
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
April 12, 2011 at 7:50 pm
After creating a new database, I will change the owner of the database to sa. It doesn't matter who I am logged in as - whether that is 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
April 12, 2011 at 5:24 pm
TheHose (4/12/2011)
Microsoft SQL Server Management Studio10.0.2531.0
Microsoft Analysis Services Client Tools10.0.1600.22
Microsoft Data Access Components (MDAC)3.86.3959
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer8.0.6001.18702
Microsoft .NET Framework2.0.50727.3615
Operating System5.2.3790
Oh it's still...
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
April 12, 2011 at 5:19 pm
Viewing 15 posts - 3,271 through 3,285 (of 6,676 total)