Is there any possible reason that I should not go ahead and install SQL Server service pack 4 on my servers? Thanks. Archer
So far, I have avoided using cursors, but I see no other way to do this. I have a db with 285 tables. I want to add 1 varchar(10) column to all 285...
I have built a DTS package to copy one database into a new, empty database. I have used two different servers, locally and remotely for both...
I am having trouble shrinking a database. The database is 14 gig, with 6 gig free space. I have tried to shrink the db with ERM, and I have tried...
This is a problem for almost every project that I work on. I get a list of location for water and/soil sampling which look like this mw-1 mw-2 mw-3...
I have a table called lab_results_import, and one of the fields is called qualifier_id. The table was empty, I imported 1 Excel spreadsheet with...
I am having problems scheduling backups. It seems pretty straight-forward, but will not work. I have tried a few different approaches. 1. in EM,...
I am trying to back up all of my databases in 1 database maintenence plan. When I try to do this, I keep getting a "Error 8114: Error converting...
I was wondering if someone could point me in the right direction and/or give me a quick breakdown on SQL Server backups. I work in Environmental...
I have a list of alphanumeric sample_id's that I would like sorted in natural sorting order. Here is a small subset: EMW12-S-46 EMW1D-GW-050405...
I am tring to build a stored procedure to query an Excel spreadsheet. The name of the spreadsheet will change every time. I would like to pass the...
I can think of kludgian ways to do this, but what is the best method to solve this problem/issue? I am trying to import an Excel spreadsheet into...
I have a system stored procedure that I am trying to create which is essentially this: if exists (select * from sysobjects where id =...
I am ordering a new laptop mainly for presentations. I will be simultaneously running MS Power Point, an in-house software package which queries SQL...
One of our groundwater modelers have brought up an issue that I am not sure how to resolve. How can you set up a numeric field to display the...
select convert(numeric(25,12), Result) from cAnalytical_Result where isnumeric(result) = 1 why does this simple select query return the error...
I am trying to install the SQL Server client tools on a co-workers workstation, but the installation aborts before even prompting me whether or not...
how do I adjust the default settings on the dts to always import numbers as numeric, and never as a floating point, and also always import all...
SELECT location, Sum(CASE analyte WHEN 'benzene' THEN result ELSE null END) Benzene, Sum(CASE analyte WHEN 'toluene' THEN result ELSE null END)...
Separate names with a comma.
