Viewing 15 posts - 91 through 105 (of 306 total)
mike.winter (6/6/2008)
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1,...
June 9, 2008 at 8:00 pm
@mike.winter
Please try Kenneth's 2 new tables and can you give us a feedback on what happened to your restoration process
@kenneth Pau
Nice work!!! thanks for the contribution...
June 9, 2008 at 7:50 pm
Thanks for the compliment and much more thanks for the positive criticism its that type of criticism that makes me going 🙂
June 5, 2008 at 6:32 pm
paksyeet (5/26/2008)
MS SQL 7 right?!?ignore it..;p
Nice name 😛
May 27, 2008 at 2:56 am
Thanks guys for your replies and suggestions the script works perfectly but now my problem is that the servers (34 servers) are with different sql versions of sp's (some with...
May 22, 2008 at 10:35 pm
PM'ed you but you didn't asnwer ;). what do you want to attain by using sp_msforeachdb?? I also did some error checking and found out that in other cases, using...
May 22, 2008 at 7:35 pm
Jeff Moden (5/14/2008)
When using DATENAME, it's already in a character format, so you don't need to use CONVERT or CAST...SELECT DATENAME(yy,GETDATE())+RIGHT('00'+DATENAME(wk,GETDATE()),2)
Never thought of this 😛 hehehe thanks... thats the reason...
May 15, 2008 at 12:40 am
What if.... ????
--=YOUR CODE HERE
IF @@error <> 0
BEGIN
--=YOUR OWN ERROR HANDLER
END
May 14, 2008 at 11:36 pm
If it is in different database but same server it can be done using the 3 part naming convention (DBName.DBOwner.Table) or (DBName..Table) if the owner is dbo only.
example :
INSERT...
May 14, 2008 at 10:11 pm
asbains8 (5/14/2008)
May 14, 2008 at 7:53 pm
Are there any implications if i change the compatibility level from 65 to 80? what if i use Enterprise Manager? in DB Properties?
May 14, 2008 at 7:29 pm
The updated script is already up and running 😀
May 12, 2008 at 7:17 pm
select * from SYSOBJECTS where name = 'table_name'
--(1 row(s) affected)
select * from dbo.table_name
--Server: Msg 208, Level 16, State 3, Line 1
--Invalid object name 'dbo.table_name'.
After all maybe the table is not...
May 11, 2008 at 11:53 pm
Posted the updated script which accept backup files with multiple ndfs im just waiting for the site confirmation for this. After running the script please tell me if there were...
May 11, 2008 at 10:42 pm
Woah!!!! thank you very much this is indeed helpfull I'll try to modify my script tomorrow. I'm almost hopeless for this one.
May 5, 2008 at 3:10 am
Viewing 15 posts - 91 through 105 (of 306 total)