I have a data field which a user of a website can populate in unicode. Now I don't really want to set the datatype to nvarchar(max) because I am worried that some malicious user is just going to upload 1gb of data! But nvarchar(4000) is also too small? So what do I do? Anything I can do...more >>

I currently am monitoring 30+ servers, and every day I need to check to see weather the previous days specified jobs ran successfully. In additional I am an ongoing maintenance plan that I have running once a week to check the integrity of the DBs, I would like to also receive an single email o...more >>

I've scoured the net for a solution to my problem and found a lot of good resources, but none that solved my issue: http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx#518504 I have a working application that opens ...more >>

We have a commercial VB6 app that uses Access. We want to start using SQLServer, and I see that Express is 'a free, redistributable version of SQL Server 2005' (quote from MS) that we could use as an imbedded database. However, if we change the app, we will have to provide a conversion path ...more >>

Hi, Wondering if anybody has had experience with inexpensive software which works for scheduled or real time synchronization of SQL databases from one server to a backup (local or remote) server. Thanks George Trojan ...more >>

When using an app that runs an sql backend i recieve the following message... "unable to load sql server oledb provider resource dll. The application cannot continue" i am unsure of how to go about troubleshooting this error and would like some more info on it. i'm running xpsp1 and have...more >>

Where do DTS packages reside ? Is there a way to automaticaaly back them up ? ...more >>

Can someone please direct me to some resources or tell me how to start the sql service that is included with small business server? I've never done it without the interface before. Thanks! Claude. ...more >>

Here is what I have... I copy a database backup from our server at work 'Users.bak'. I have a have a network storage device that I copy it to from work and then bring it home. What I would like to do is restore the User.bak db to my network storage device. This is a fairly large DB and I'm ...more >>

Hi, I have created a Visio page with tables and relations. Could I generate sql script for creating tables and relations according this visio page? Thanks. ...more >>

Dear Experts, I have a following SP and I would NOT like to see data displayed in query analyser. Since I have EXEC (@vSQL) statment it is displaying data in QA. If I have 100000 records executing I am getting "Resource is Low, Some results are dropped error." It is true becuase it is trying to...more >>

Is there a simple way to join these two commands so I can get a single list of both the databases names and the entire list of table name with index names? SELECT name FROM master.dbo.sysdatabases DBCC SHOWCONTIG WITH FAST, ALL_INDEXES, TABLERESULTS, NO_INFOMSGS I am just looking for the ...more >>

We had a crash on the partition that houses our log files. We recovered most databases from backup, but a few were marked 'suspect' and I didn't have a good backup. I used sp_detach_db to detach the databases, and when I tried to reattach them, I got warnings that the log files were corrupt. ...more >>

I run sql server, the analyser and get a diagram of the "Costs" when something there shows Cost 100% and I already know that this query takes soooo much time what can I think of? Does 100% cost means that nothing is working after this point? In pure life 100% cost means that something is devalu...more >>

Hi, Is it possible to get a count of how many times an sp has been called on a server? I know I could set up a trace on a server for sps and then peruse the trace for a particular sp and count that way. But I would like a more efficient way if there is one. Thanks. - Komp ...more >>

Hi all! I'm trying to do the following: select * from Estates where case (Action) when(1) est_ZipCode BETWEEN 12000 AND 12999 OR est_ZipCode BETWEEN 14000 AND 14999 end when(2) est_ZipCode BETWEEN 16000 AND 16999 end when(3) est_ZipCode BETWEEN 11000 AND 11999 OR est_...more >>

Hi Is there a way to attach a /mdf file to new server with a different file location?? For example after safely shutting down sql server on the old machine (which is no longer accessible) I've tried to reattach the file which is in the folder d:\mssql\data but get the following error messag...more >>

Situation: Stored procedure 1 which is related with Stored procedure 2 which has parametar. Does anyone knows how to transfer value of some field from stored procedure 1 to parametar in stored procedure 2? Regards, ...more >>

Hi all! I have stored procedure "SPStorniranjeUKRP" with two parameters, @VrNaloga (smallint) and @IdNaloga (smallint). When I try to execute this procedure from VBA code (MS Access) I use following command: DoCmd.RunSQL "EXEC SPStorniranjeUKRP @VrNaloga= " & [Forms]![FRMUlazneKalkulacijeRP...more >>

Is there an easy way to import CSV files into a SQL Express 2005 database? I am using perfmon to capture Performance Counters for some of the servers I monitor, and I'd like to dump all of these counters into a SQL Express Database. Currently I have the perf counters going into CSV files, e...more >>

Hi All, Now I encounter a very strange error. There is a table A which contains a varchar(10) column fieldA. Then if we execute the following SQL, select * from A where fieldA = 1234 we will get the error message: run-time error '3146' 22005: Syntax error converting the varchar value 'd...more >>

Hi all! I have one update SP and I need to do some calculations in that SP. Problem happens when this calculation results with null string. I would like to have result like this: If Isnull(CalculatedField) then CalculatedField=AnotherField else CalculatedField=Calculation end if Can I...more >>

HI All, I have a table which has got the following columns plus more pkid id int, value varchar(50) flg bit I want to set up a constraint so that there can be only one 345,blah where flg=0 good records pkid,id,value,flg ------------------------- 3,345,blah,0 4,345,blah,1 5,345...more >>

hi all, can someone tell me how to concatenate text datatype, Or is there any data type which is supporting length of 32767 characters. As maximim limit of varchar is 8000, and i want to store more than that. Any help will be truely appreciated. thanks in advance. ...more >>

Dear all, In SQL Server 2000 , how to get distinct records sort by one field . Example SELECT DISTINCT A FROM tblTEST ORBER BY B Here, In Table Field 'A' contain more than one same data... Field 'B' contain all are different Data...... I wan...more >>

I have a simple query that takes more than a minute to process, normally. When I hard code the parameter value into the query, it executes in less than one second. I am joining between a view on a linked server and a view on the local DB. Both servers are SQL 2000 SP3a. The only difference ...more >>

Hi Can you help me with a Select statement? It should be simple, but I am lost. It should be something quite opposite to the JOIN statements, as they will allways give me NULLs for non matching values, but I actually want nonmatching values. I have two tables. How to query the two tables (belo...more >>

Hi, I am currently facing extreme disk utilization on a system that is using drive e: and f: for several databases and indexes. Is there a way to check which .mdf or .ldf (or other) files are causing this high utilization? Third party tool maybe? TIA for any hint, Regards DC ...more >>