Viewing 15 posts - 91 through 105 (of 307 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,...
"-=Still Learning=-"
Lester Policarpio
June 9, 2008 at 8:00 pm
@mike-2.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 though it seems like...
"-=Still Learning=-"
Lester Policarpio
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 🙂
"-=Still Learning=-"
Lester Policarpio
June 5, 2008 at 6:32 pm
paksyeet (5/26/2008)
MS SQL 7 right?!?ignore it..;p
Nice name 😛
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
May 15, 2008 at 12:40 am
What if.... ????
--=YOUR CODE HERE
IF @@error <> 0
BEGIN
--=YOUR OWN ERROR HANDLER
END
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
May 14, 2008 at 10:11 pm
asbains8 (5/14/2008)
"-=Still Learning=-"
Lester Policarpio
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?
"-=Still Learning=-"
Lester Policarpio
May 14, 2008 at 7:29 pm
The updated script is already up and running 😀
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
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...
"-=Still Learning=-"
Lester Policarpio
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.
"-=Still Learning=-"
Lester Policarpio
May 5, 2008 at 3:10 am
Viewing 15 posts - 91 through 105 (of 307 total)