happy new years dbforums

remember if you drink too much, get a taxi and charge it to your company.i am my company

and besides, i'll be at home new year's eve

just me, a coupla beer, and maybe a bowl game ...

call me a cab from the living room to the bedroom, eh

:)|||oh, wait, there's an nfl game on new year's eve

the geeeeeeeeeeeeeeeeeeeee-men at da raaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaiders|||:p :D A VERY HAPPY NEW YEAR TO ALL THE FOLKS :p :D|||Happy New Year, all, may your DBCC CheckDBs all come out clean.

Happy New Years

I just wanted to wish everyone a Happy New Years and I wanted to thank all submitters to this forum for breaking up my code monkey workday and cutting into my productivity and I have found many of these discussions helpful in my preperation for my long procrastinated MCDBA exams.

Get hammered and do not drive.Happy New Year to you also Thrasy, I too and going to be pursing my certifications in SQL also gonna start with the 70-228 certification I really want to pass it.

Question has anyone ever used the MCSE SQL Server Adminstration VTC by Sybex? I'm finding it quite helpful but I hope it helps me to pass the test|||I am using a combo of Microsoft Press Books, these forums, OJT and I have been looking around for some good test emulation software but I have been talking about doing it since the millenium.

I think I am starting to hit my salary ceiling so I have to make a change this year and start beefing up the resume.

Happy New Year to you also Thrasy, I too and going to be pursing my certifications in SQL also gonna start with the 70-228 certification I really want to pass it.

Question has anyone ever used the MCSE SQL Server Adminstration VTC by Sybex? I'm finding it quite helpful but I hope it helps me to pass the test

Happy New Year to one and all !

Wishing all of you a splendid 2007. Thanks to all of your contributions...
It sure is nice not just to have questions answered but also read the
answers to questions posted by others.
And a special thank you to those answering our questions. Sure wouldn't be
fun resolving SQL issues if not for you.I hope all of you can take a break
today and enjoy the New Year before getting back in action again out here ;)
Select 'Happiess to All' from LIFE Where Each_and_Every_One is Equal HAVING
No_Hate_In_The_World
I'm not sure how long this query might take, but if you adjust the timeout
option, it just might run. We shall see
"Hassan" <Hassan@.hotmail.com> wrote in message
news:efy8jCXLHHA.960@.TK2MSFTNGP04.phx.gbl...
> Wishing all of you a splendid 2007. Thanks to all of your contributions...
> It sure is nice not just to have questions answered but also read the
> answers to questions posted by others.
> And a special thank you to those answering our questions. Sure wouldn't be
> fun resolving SQL issues if not for you.I hope all of you can take a break
> today and enjoy the New Year before getting back in action again out here
> ;)
>
>

Happy New Year to one and all !

Wishing all of you a splendid 2007. Thanks to all of your contributions...
It sure is nice not just to have questions answered but also read the
answers to questions posted by others.
And a special thank you to those answering our questions. Sure wouldn't be
fun resolving SQL issues if not for you.I hope all of you can take a break
today and enjoy the New Year before getting back in action again out here ;)Select 'Happiess to All' from LIFE Where Each_and_Every_One is Equal HAVING
No_Hate_In_The_World
I'm not sure how long this query might take, but if you adjust the timeout
option, it just might run. We shall see
"Hassan" <Hassan@.hotmail.com> wrote in message
news:efy8jCXLHHA.960@.TK2MSFTNGP04.phx.gbl...
> Wishing all of you a splendid 2007. Thanks to all of your contributions...
> It sure is nice not just to have questions answered but also read the
> answers to questions posted by others.
> And a special thank you to those answering our questions. Sure wouldn't be
> fun resolving SQL issues if not for you.I hope all of you can take a break
> today and enjoy the New Year before getting back in action again out here
> ;)
>
>

HAPPY NEW YEAR TO EVERYONE

HAVE A HAPPY AND A SAFE NEW YEAR
MSWHappy New Year to everyone in our community... 2004 is going to be a great
year!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"msw" <msw(removethis)@.hotmail.com> wrote in message
news:%23dYX%2358zDHA.1708@.TK2MSFTNGP12.phx.gbl...
> HAVE A HAPPY AND A SAFE NEW YEAR
> MSW
>

HAPPY NEW YEAR Everyone

Just got cut loose...
have a safe and happy new year!
anyone seen my salt shaker?
damn what a time to misplace it...Happy new year, Brett. Where is the famous query?|||DECLARE @.NewYearsEve datetime
SELECT @.NewYearsEve = 'Dec 31 2003 17:00:00'
SELECT DATEDIFF(mi, GetDate(), @.NewYearsEve)/60.00 As Hours_till_Margaritaville|||May the new year bring happiness to you all.

Happy New Year !!!|||Happy new year everybody ..

Big thanks to all the guys/girls who made this forum valuable.
I want to mention: Brett Kaiser, MCrowley and blindman ..

Thanks a lot guys!|||Originally posted by AccessUser
Happy new year everybody ..

Big thanks to all the guys/girls who made this forum valuable.
I want to mention: Brett Kaiser, MCrowley and blindman ..

Thanks a lot guys!

I second that !!!|||so, what is everyone's New Year's Resolution?



mine's 800x600

hee hee

:cool:

rudy
http://rudy.ca/|||I resolve not to make any resolutions...

Happy New Year and Christmas everybody! Another question:

Can i alter a table included in a Publication?

I am having problems with that.

Yes, if you are using SQL Server 2005. Additionally, if you are using Merge replication your publication compatibility should be set to 90RTM.

With this, you can alter a table and add/drop/alter a column and this DDL action will be propagated to the subscribers.

|||

For DDL opertion on replicated object tables , in SQL 2000 you can use sp_repladdcolumn/sp_repldropcolumn to add/remove the table columns

|||

Mahesh Dudgikar wrote:

Yes, if you are using SQL Server 2005. Additionally, if you are using Merge replication your publication compatibility should be set to 90RTM.

But if my compatibility level is set to 80 - can I change it to 90, call ALTER TABLE, and then change it back to 80? Will it cause any problems?

|||

You can change the compat from 80 to 90 and then use alter table.

However once the publication compatibility is set to 90, you cannot go back to 80.

|||If your compatibility is set to 80 then you are running in SQL 2000 mode. So you have to use the sp_repladdcolumn/sp_repldropcolumn to add/drop columns.|||

Mahesh Dudgikar wrote:

You can change the compat from 80 to 90 and then use alter table.

However once the publication compatibility is set to 90, you cannot go back to 80.

1. Is compatibility level defined separately for DATABASE and for PUBLICATION?

2. If not: I have tried to change the compatibility level for unpublished database (both upgrading and downgrading), and it succeeded. Does publication lock downgrading of compatibility level of the database?

Thanks in advance!

|||

Sorry for not being clear.

Above, I meant @.publication_compatibility_level of the publication setting, not the database compat level.

They are separate settings. The database compat level has nothing to do with the DDL method (sp_repladdcolumn and alter table)

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish