Viewing 15 posts - 19,621 through 19,635 (of 22,202 total)
Gail's 100% correct.
I've got some 64 bit servers and I haven't seen this behavior, so I don't think it's the 64 bit alone that's causing the issue. Are there any...
September 4, 2008 at 5:51 am
Take a look at the services running on the server. Analysis Services, the OLAP engine, is completely different than SQL Server. That will till you which you have. However, you...
September 4, 2008 at 5:49 am
This is from BOL. I'd suggest trying it.
SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent
FROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');
September 4, 2008 at 5:44 am
First thing I see, do you reall need to do a left join to that sub-select. If I'm seeing the logic correctly, it's looking for any of the values that...
September 4, 2008 at 5:42 am
And then only if it's a publicly traded company. I've been working for a private company for years, so I'm only aware of SOX when I hear people complaining about...
September 4, 2008 at 5:33 am
You don't have to create the shell to restore a backup to a new database. You just have to move the data files. I explained the GUI method in the...
September 4, 2008 at 5:28 am
I am such a dope sometimes.
http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/%5B/url%5D
September 3, 2008 at 12:28 pm
It sounds like your maintenance plan is set up right. The scenario you described is not because of a database or log first or second, but because you have to...
September 3, 2008 at 12:22 pm
Maybe I'm confused (hardly a new case), but however many log files you've backed up, you'll have to traverse them unitl you get to the log where the end time...
September 3, 2008 at 12:11 pm
You can't really do logs first. You have to restore the database and then a series of logs and the backup has to be in the same order.
September 3, 2008 at 11:55 am
Those files are not compatible with Management Studio.
As to where... it really depends on your shop and the processes there. For example, we use Visual Studio Team System Database Edition...
September 3, 2008 at 11:53 am
Didn't I answer this one already today for you?
September 3, 2008 at 10:33 am
But the issue is the error message:
"nvarchar value "2147486776" overflowed an int column"
If you're selecting into a bigint variable from a big int column, where is the nvarchar and the...
September 3, 2008 at 9:14 am
Have you tried running the query against the base table?
Something is introducing a string in there.
September 3, 2008 at 9:08 am
And RecId is, for sure, a bigint?
September 3, 2008 at 8:39 am
Viewing 15 posts - 19,621 through 19,635 (of 22,202 total)