Image was inserted into the table using simple UPDATE statement of actual VARBINARY value which I got from another table.

Not sure how the image was inserted into that...

Exactly, that is what I was asking for.

Can you please explain to me on how exactly to achieve that?

Which tool should I be using?

Thanks!

Thanks!

The link covers Primary Key and Default Constraint, but not the Foreign Key and Unique Constraint.

Do you have any pointers on those?

Thanks for your response.

The database I'm dealing with is not set to readonly. Application does only reads from it. We do occasional updates every month, but during that process we...

Thanks.

Got the below Table-Valued Function logic from:http://www.sommarskog.se/arrays-in-sql-2005.html#CSV (Click on Erland's CLR version under CLR) via the link you provided http://sqlblog.com/blogs/aaron_bertrand/archive/2010/07/07/splitting-a-list-of-integers-another-roundup.aspx

Table-Valued Function that unpacks the string into...

Thanks!

Can you please give an example of how to do it?

I'm quite new to sql server and would really appreciate the help.

Thanks

Thanks!

I uninstalled from Control panel -> Sql server 2008 R2 -> It asked me which specific instance to uninstall -> selected the Sql server 2008 developer R2 instance.

I uninstalled Sql server 2008 developer instance and re-installed it.

This fixed the issue.

I now see SQL profiler under Tools menu in SSMS.

Thanks for all your suggestions.

Thanks!

I did install REDGATE tool in my machine recently. Not sure if that changed something.

Correction: I did find PROFILER.EXE in my PC

Its located in: C:\Program Files\Microsoft SQL Server\100\Tools\Binn

Should I launch that?

How do I make it avaialble under Programs?

Why doesnt it show up in SSMS...

personal computer or work? - Work

local admin? - Yes

have you logged in by chance with the wrong account? - No. I have be loggig it the same way for a...

No, I do not see it under any of the Sql server folder under Programs.

Thanks!

Thanks!

When I execute SELECT USER_NAME(), I get the result as guest.

Question 1:

How do I find out if my windows user id is a part of domain admin group (or) windows...

Sure, the script could be made as a Stored procedure.

I have a embedded RAIMA database and want to extract its schema structure. I came across your post in which you have suggested lookign at http://www.linuxdevices.com/news/NS8794867415.html

I tried...