Search results for query: *

My bad. In a jiffy, I assumed you wanted to create a table with data stored the way you said you want to. Creating a view will not change the data structure. But, as SQLBill pointed out as well, what you are really looking for is a query with output in that format. Right?

In Query analyser, run this in the database your table is in. ALTER TABLE Table_Name ALTER COLUMN ColName datatype COLLATE collation_you_want To change the defalut collation for the database, do a ALTER DATABASE DBName COLLATE collation_you_want. Note that the new collation for the...

By having muliple values for the same record you would kill the atomicity of the PatientID column? Why would you want to do that? It'll denormalize your data and also make it slower and inefficient. However, if that is the way you want to present the data, you could do the formating on the...

I do daily backups using backup exec from Veritas. That apart, on a weekly basis I backup all the data on disc. I use the Maintenance plans to do that. Maybe I should try to do it thru a C# application using SQLDMO. Just to get a perspective, how many databases and database servers do you...

Thanks SQLBill for your suggestions. I like your suggestion to create a play database. I'll go ahead and create one. - try and do some programming but not the one who would take to it willingly. - do a lot of DTS but mostly for just migrating data from one source to another. - use...

I know this is not a technical question on SQL Server but as so many brains frequent this forum, I thought this is the place to get some answers. I administer the SQL server database of a company with sales under $100 million and our database size is less then 100G . As far as the databases...

SQL Server 2000 is designed to consume as much memory at it needs to do the task at hand. It will not release the memory until another application or the OS needs it. It sure is not a bad install or perhaps bad RAM. This is typical SQL Server behaviour. You can limit the max amount of...

The table is not big. It has about about 12000 rows. I can see 200 rows under the preview, which I guess is the default. To I run the job under sql services account, do I have to run the SQL Server Agent under that account. I currently have it running under System Account. I have not...

I delete all the records in the destination table before I load it with data.

I created a DTS package that copies a table from one database to another. It copies all the rows when I run it manually. If I run it as a scheduled job in MS SQL Server 2000, it does not copy all the rows. I created a exception file to trap the exception and it says...

The second message tells me that 'Fund Transaction' has a relationship with another table in your database. You will have to delete the relationsip first and then delete the table. But if you do that, you would destroy any referential integrity your tables may have and you may end up with...

Thanks Gopala. That worked.

danceman: Connectivity is not the issue here. What I want to do is UPDATE data in a SQL Server table using data in the spreadsheet in one step using DTS.

I would like to update selected records in a Sql server table from an MS Excel spreadsheet using DTS. I tried to do this using Transfrom Data Task but it only lets me select data from excel. It does not let me write a update query. I could bring the data into a temp table in sql serer and...

Jay Stopping the service is a bit drastic. I cannot do that on the prodiction server. What is odd is that SQL Server knows the connection has been termintated and after about 3 minutes the process details no longer show up under Current Activity>Process Info. If it were a ghost connection...

I connect to a SQL Server database thru a .net web app. Now, if I go to Current Activity in EM I can see the details of the connection. However, EM show details of the process/connection even after I kill the application that connects to the database. It shows the status as "SLEEPING" and...

Thanks Veep. That helped.

hi, I am a newbie in C# and I cannot figure this one out. I want to color the rows in a datagrid based on the value in the first column. How do I do that in C#? Thanks.

Good point SQLSister. I did not think of that. vongrunt, On a NT machine a Unicode app runs faster then a character string app. Do you think one could extend the same logic to Unicode in SQL Server?

I want to store Unicode data of varying length in a column. The length could vary from anywhere from 100 bytes to 2000 bytes maybe more. Would I suffer a performance hit if I set the column lenght to maximum, that is 4000? Or, would be better to limit it to little over 2000 bytes? What are...