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...

Okay, my post above looks strange to me.

Sample code for you to play with. You will need to put the data into a text file, and be sure to modify the line where I have the...

Here is more code for you to take a look at and play with.

CREATE TABLE [dbo].[MainTable](

[DrugName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CalendarYear] [int] NULL,

[CalendarMonth] [int] NULL,

[CalendarQuarter] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PatientID] [nvarchar](255) COLLATE...

The UDF is a Dynamic Tally table. Take the time to read the second to last article I reference below in my signature block regarding Tally tables. You...

Nardig (6/30/2009)

---

ok i have one table with MemberID, Name, Surname and City and information for inserted on this table and i have on text file for example 1001, John, Smith,...