You would need some application to query the database and then stream the image data and view it. These are just bits to SQL Server, it has no idea how...

Richard,

Nice editorial and that's a very interesting SQL product. There are lots of interesting applications for a product just like this and I wish Dr. Hipp the best of luck.

It...

You'd need to post more information about what you are doing or what the code is.

There could be any number of problems. If you run Profiler with your login credentials,...

It's a security issue with the accounts on Server 3. It could be your SPN isn't correct on that server or there's a timing issue (kerberos is used).

http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F811889&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNG2tTrJFOIYpo4EZa9v3b4WNAS_6w&sig2=514i745fU9eHOSD4kRnePw

http://www.google.com/url?sa=t&ct=res&cd=2&url=http%3A%2F%2Fwww.sqlservercentral.com%2Farticles%2FInstallation%2Fcannotgeneratesspicontext%2F929%2F&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNGps3wNFPmXQU-u9vxb-2ULrFnh7A&sig2=oCWspssnEe-b2WSKSogFFA

You need to read up on replication in books online to understand what it is and if it will meet your needs.

With snapshot replication, you'd move the entire database...

You can do a partitioned table or partitioned view that will help here. Look these up in books online and be sure you set the security the same on both...

Which database maintenance script? The maintenance plan wizard? The maintenance plan designer. There is a task (maintenance cleanup) to handle this.

Have you rebooted? I've seen this where the plan gets booted for some reason and then dies. I haven't seen a good way to fix this. Hints can help at...

Lowell has a good idea. You could do a backup /restore (with NORECOVERY), then copy logs, repeat until you're only 1 minute behind. Then backup the tail, restore, detach the...

I think you mean sp_who.

What does the DTS package do? More information would help.

This is a cross tab query.

You need to do something like.

select a.name

, b.name

, c.name

from Mytable a

inner join myTable b

inner...

It really is a slowly changing dimension, but in an OLTP system, I think it fits more as an auditing item as Jeff mentioned.

I'd store it separately as it's entered...

varchar is not Unicode.

You can change the data type, but any unicode data would be lost or cause errors during the conversion. Only the N data types (ntext, nvarchar, nchar)...

I have seen this before and it is frustrating. Try a stored procedure and see if you can get it to behave better. Also, are you executing the same query,...

Very interesting link. Did it help? Are you XP -> XP?

I haven't seen this error, but the guest user makes some sense.