i believe it's becasue you want to update the alias "o",

try this instead:

CREATE TRIGGER [dbo].[tr_intr_ob_problem_list_]

ON [dbo].[ob_problem_list_]

FOR INSERT

AS

...

documenting all users and roles, any CLR assemblies, and mail settings for database mail is handy too(even though the mail settings are in msdb)

linked servers and synonyms and custom...

we are looking for something like this, that anyone on the interwebz can copy and paste so we can build sample queries for you to test with:

CREATE TABLE [dbo].[TAGTABL] (...

if you've gotta do it via TSQL, instead of stepping out via SMO to get it , i've spent a lot of time refining a few stored procedures to do...

the function attached to this article is recommended by myself any my peers:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

vijayarani87.s (7/18/2012)

---

Hi I need to take the result by passing more ID, below is the sample query, I am getting error converting vachar to INT ERROR. Because data type for...

nope no way to force it.

you can use MAXDOP to limit the parallelism, but there's no MINDOP feature.

if the execution plans were the same, it should use the same paralell...

i haven't done it since i discovered CLR, but it's possible with bcp; google bcp binary blob for examples, but here's one:

bcp "select document_binary_data from databaseName.dbo.tableName where id...

ok i know that you can create a table on a linked server using EXECUTE AT, but i think you have to create the table first, and then insert into...

well here's one way using CLR:

if you were to install Elliot Whitlow's project at http://nclsqlclrfile.codeplex.com/

you could save the binary to disk on the server, and then send the attachment.

--MSPSaveFileImage

-- ...

what did you try?

what did not work?

did you upgrade the driver like Gail suggested?

did you try the suggestions i posted,and what were the...

is the database set to single user?

select * from sys.databases WHERE user_access_desc = 'SINGLE_USER'

if it is, and should not be, you need this command:

ALTER DATABASE [YourDatabaseName] SET MULTI_USER

for a cross database query, the login needs to be either a user in both databases, or in a group that exists in both databases.

so for a specific example, you...

not sure what you need, sorry.

run the first query. does it return...

yes it's possible. SQl lets you restore previous versions of SLQ server, up to three versions behind, i think?( so SQL 2008 can restore SQL 7 or SQL 2000 or...