Viewing 15 posts - 30,376 through 30,390 (of 39,757 total)
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...
December 10, 2007 at 7:25 am
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...
December 9, 2007 at 9:12 pm
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,...
December 9, 2007 at 9:10 pm
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).
December 9, 2007 at 9:08 pm
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...
December 9, 2007 at 8:40 pm
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...
December 9, 2007 at 8:38 pm
Which database maintenance script? The maintenance plan wizard? The maintenance plan designer. There is a task (maintenance cleanup) to handle this.
December 9, 2007 at 8:37 pm
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...
December 9, 2007 at 8:34 pm
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...
December 9, 2007 at 8:31 pm
I think you mean sp_who.
What does the DTS package do? More information would help.
December 9, 2007 at 8:29 pm
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...
December 9, 2007 at 8:28 pm
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...
December 9, 2007 at 1:08 pm
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)...
December 9, 2007 at 12:40 pm
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,...
December 9, 2007 at 12:39 pm
Very interesting link. Did it help? Are you XP -> XP?
I haven't seen this error, but the guest user makes some sense.
December 9, 2007 at 12:38 pm
Viewing 15 posts - 30,376 through 30,390 (of 39,757 total)