What you are going to need to look into is dynamic sql. I suggest that your start first with looking it up in BOL (Books Online, the SQL Server...

They do, each table can have a single column defined as an IDENTITY column.

Unfortunately, without further explaination from the OP regarding what he is looking for, all we can do is offer up guesses.

Nope, you can't mark a thread as answered. Reason being some one may look at your solution and provide you with another alternative (note, I didn't necessarily say better)...

When you talk sequence number all I can think of are identity columns in tables. can you explain in greater detail what your looking for?

In SQL Server 2000, you may need to make those DDL statements dynamc sql and run them with the EXEC command in your stored proc.

At this point I'd say shrink the Primary file group. If all you have there now are system objects, no user objects, you can reclaim the unused space.

Not really enough information here to assist. It might help if you could provide the entire error message you have in the application log plus a few entries on...

Your directory structure may differ, but this is where I find my output files for the maintenance plans run on one of my servers:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Look there and you...

I'm not going to tell you how to setup your databases. You need to make a decision on how you want it based on the input you have been...

To really help you we need a few things from you. Please provide the DDL (CREATE TABLE) statements for the table(s) involved in your query. Sample data in...

Krasavita (7/1/2009)

---

Thank you for your help, so just be cleared.I will find out how much data comes daily,but in mean while. This is how I will set the db settings:

For...

Couple of things. One, setting the data file to grow in 1 MB increments is not quite right, especially since the database is apparently about 4 GB in size....

Due to the depth and breadth of this request, the best I can do is tell you to start...

Not sure what...