the parameter @recipients for msdb.dbo.sp_send_dbmail expects a semicolon delimited list of recipients; there's no limit to the # of recipients, since it is a varchar(max) definition;

so something like...

I think this is data input validation that needs to occur on the asp page, and not at the server or even SQL server; a simple javascript alert is all...

maybe there is a database trigger that is causuing the issue, and not one on the table itself?

--db level triggers

select * from sys.triggers where parent_class_desc = 'DATABASE'

if it's not in the default trace, which onyl keeps track of "whodunnit" information on DDL stuff for a limited time, and you do not have any other traces in...

I agree the issue is going to be the trigger....show us your audit trigger code; if both fields are money or decimal types, the error raised cannot be from the...

parameter sniffing.

an execution plan is created when the procedure is created, and the SQL engine makes an assumption that since the default values are NULL, the best execution plan should...

ok, I just realized that the shortcut command you needed was for {slash L}, not {slash R]

ROWTERMINATOR =

vbCrLf = CHAR(13) + CHAR(10) = \n

vbCr = CHAR(13) = \r

vbLf =...

why not just call the file directly? why do you have to do the cd command, when you know where the file is anyway?

create table #Results (

ID int identity(1,1) NOT...

Tara-1044200 (8/26/2010)

---

can i create a sql role and add some users(50+) and give them only read access to all the databases in the server. What would be the best way...

i have this CREATE TABLe in my snippets, so i would assume drop table works the same way:

EXEC sp_addlinkedserver 'SeattleSales', 'SQL Server'

GO

EXECUTE ( 'CREATE TABLE AdventureWorks2008R2.dbo.SalesTbl

(SalesID int, SalesName varchar(10))...

this is completely untested, as you didn't provide the schema or sample data.

note i'm assuming there is a column "remarksID" so the list of remarks can be ordered....only YOU know...

we cross post each others same answers just a bit too often 🙂

i don't think the CREATE USER command allows variables; you'd have to switch to dynamic SQL instead:

declare @groupname varchar(50),

@sql varchar(1000)

SELECT @groupname =...

scottichrosaviakosmos (8/26/2010)

---

i have a table and i am writing a procedure. my table has a unique column eg:u_column .

Now, i want to know on which u_column its which columns are...

you want to read the windows registry to get the collation before the installation, i think?

I'm only sure of how to get it afterwards....maybe you could run a script to...