Larry Rebich (5/27/2009)

---

It is done when SQL Server is installed by Visual Studio so it can be done programmaticly.

Who knows how to use SMO/VB.Net to create an Instance of...

RBarryYoung (5/27/2009)

---

Hey, congrats from me too, Lynn!...

Imu92(5/27/2009)

---

Hi Lynn,

your date routines are really helpful!

One question though:

When I try "set @ThisDate = '20090524'" I get "2009-05-25 00:00:00.000" as Beginning of this week (Monday) which is "strange" - at...

Absolutely NO GUARANTEES on this code. I have nothing to test it against.

WITH UserGroups (

group_id

) AS (

select

group_id

from

f_get_groups_user(@user_id)

)

SELECT

...

Nope. No sample data or expected results.

Please read the first article I have referenced below in my signature block.

Where are we again? Oh yea,

44 bottles of beer on the wall, 44 bottles of beer! Take one down, pass it around, 43 bottles of beer on the...

I think part of your problem is the mixing of join syntax. You are using both new and old style joins. First thing I'd do is rewrite the...

Can't help fix something if we don't have the code, the DDL for the tables involved, sample data (in a readily consummable format), expected results based on the sample data.

Please...

GSquared (5/27/2009)

---

Lynn Pettis (5/27/2009)

---

Roy Ernest (5/27/2009)

---

That is my point, You, Gail, Lynn,Steve and many others have been saying that this is not be done. These are the consequences. But the...

Per Books Online (BOL), which should be your best friend next to SSC, synonyms can only be created for views, tables, functions (CLR and T-SQL), and stored procedures. Can't...

Realizing that this behaviour may also change in a future version of SQL Server, but is independent of the DATEFIRST setting, take a look at the date routines here: Some...

prash.dark (5/27/2009)

---

I have to use hudreds of select queries. So i can not create Synonyms for every table.

I tried creating a synonym for database object

i.e.

Create...

Roy Ernest (5/27/2009)

---

That is my point, You, Gail, Lynn,Steve and many others have been saying that this is not be done. These are the consequences. But the same person who...

Besides using Dynamic SQL as was also suggested, not really. I think...

You know what, table DDL, sample data (in a readily comsummable format), and expected results based on the sample data would really...