Viewing 15 posts - 35,686 through 35,700 (of 49,557 total)
Suresh B. (11/24/2009)
I thought there is some way to restore as the compatibility is not changed.
Compatibility level has nothing to do with database version. The compatibility level just affects...
November 24, 2009 at 8:39 am
simegh (11/24/2009)
I have not backup. I set emergency mode and repair.
You do realise that you may very well have lost data. You will certainly have lost any transactions that...
November 24, 2009 at 8:27 am
Post execution plans?
November 24, 2009 at 12:26 am
Duplicate post (and possible spam). No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic823640-6-1.aspx
November 24, 2009 at 12:22 am
Joie Andrew (11/23/2009)
It appears that from the error that either the log file is missing or is not in a location that it was expecting it to be in.
As far...
November 24, 2009 at 12:21 am
hydbadrose (11/23/2009)
The function name I had in caps and the system has in lowercase.
That'll only make a difference if you've installed the server with a case-sensitive collation.
November 23, 2009 at 12:28 pm
You can have as many AFTER INSERT triggers as you like. It's the INSTEAD OF triggers that are limited to one per operation.
What's that trigger supposed to do?
November 23, 2009 at 9:27 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2009 at 9:26 am
Got a backup? Ask your client. It's the best way to fix this.
If not, try hacking the DB back into the server. See the procedure here: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
If you go that...
November 23, 2009 at 9:10 am
If it does, then create a new column with the varbinary type. Update it from the varchar with convert, then drop the varchar column and rename the varbinary.
November 23, 2009 at 9:08 am
Grant Fritchey (11/23/2009)
Yep. Gail nailed it (shocking I'm sure).
Just finished writing a blog post on 'optimal' join types. Virtually a copy-paste from blog to forum.
November 23, 2009 at 8:51 am
sanya.ibrahim (11/23/2009)
Sorry, I forgot to write the "from" clause in the code I wrote here in the forum. The actual sp has the 'from' clause.
Then post the actual sp.
November 23, 2009 at 8:34 am
First thing to note is that 1 row in each table is not enough for any meaningful conclusions. You really need a couple hundred at least.
As far as I'm aware,...
November 23, 2009 at 8:27 am
ALTER TABLE <Table Name>
ALTER COLUMN <Column Name> <New type information>
See Books Online for full details. Look under ALTER TABLE
November 23, 2009 at 7:39 am
I'm not much of a steak fan (or beef in general much), but I think I'll be trying out the steak recipe soon.
November 23, 2009 at 2:13 am
Viewing 15 posts - 35,686 through 35,700 (of 49,557 total)