Viewing 15 posts - 6,316 through 6,330 (of 6,676 total)
Check the SQL Server logs - should be something in there related to the drop/detach of the affected database.
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
July 21, 2008 at 3:08 pm
jonathanmreynolds (7/21/2008)
Once I have an understanding of the relationships, it really shouldn't be that hard to figure this out.
Hi Jeffrey - thanks again for your time assisting me with this....
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
July 21, 2008 at 2:46 pm
It probably did not install of the express edition - but, you probably missed the check box to install the database engine.
Try re-running the setup and make sure you select...
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
July 20, 2008 at 1:58 pm
Okay, then it should be installed. How are you determining that it is not installed?
What services do you have that start with SQL*?
Try opening SQL Server Configuration Manager and...
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
July 20, 2008 at 12:26 pm
levani (7/17/2008)
What I am trying to do is to export the Data from tables to Excel fiel
I creted 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
July 20, 2008 at 12:18 pm
You probably installed the Express version and not a trial edition. The express version does not come with the agent.
To verify, run: SELECT @@version; from a query window 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
July 20, 2008 at 12:14 pm
If you are going to be passing in all of the parameters, then no - you don't need to coalesce the parameters.
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
July 20, 2008 at 12:07 pm
No - don't understand what you are asking. Please read the following article and re-post your question:
Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
July 20, 2008 at 11:08 am
Are you asking about a database being backed up?
Look in BOL at BACKUP and RESTORE to see how to backup a database and restore to another 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
July 20, 2008 at 10:52 am
jbloes (7/20/2008)
The problem...
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
July 20, 2008 at 10:49 am
george sibbald (7/20/2008)
this is in the 2005 forum but you stated you are using sql 2000, in that cases you cannot use schemas
George - I must of skipped right over...
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
July 20, 2008 at 10:30 am
The only way I can think of would be to create roles with the appropriate schema level permissions. Once you have a role defined, and assigned the users/groups 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
July 19, 2008 at 2:44 pm
A table, by definition, has no order - so, there is no way to return rows in the order they were entered.
The only way you can write a query 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
July 19, 2008 at 2:39 pm
Johannsky (7/19/2008)
Hello,Another issue i encounter today, does SQL server 2005 limits the data transfer on up to 50GB only when backing up on a network.
Thanks again.
We had a similar issue...
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
July 19, 2008 at 10:16 am
jonathanmreynolds (7/19/2008)
select
g.arrival as 'Arrival'
,g.departure as 'Departure'
...
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
July 19, 2008 at 9:51 am
Viewing 15 posts - 6,316 through 6,330 (of 6,676 total)