you'll have to purchase the 2008 Developer Edition in order to work with cubes/analysis server/BIDS/Integration Services;

those functions are not included in the free express versions. the express version comes with...

there is no difference; SQL is smart enough to know there is no reason to retrieve rows for the count() function, and does it the fastest way possible; count(*),count(someColumn) and...

what you want to do is create a few roles in your database first. once the roles are created, then you want to remove your user from the db_owner role,...

changing lock styles has a very minimal impact on queries, especially in SQL2005 and above.

For example, unless you have a LOT of updates going on every x milliseconds, SELECT...

would it be easier to create a role in the production database that has execute access to the 50 procedures, and then use a variation of Seth's script to add...

naldo.samuel (1/10/2010)

---

ei can you send me a file of SQL 2000 that is already installed my email add is samuel.naldo@yahoo.com,Because i cant run mine it always have error in the...

by default, all columns are added to the end to a table; to add one in the middle, you have to rebuild the whole table.

SQL doesn't care about column order...

just use a case statement to check for the number of periods; if it's two or more, use your formula, else get the full string.

typical results:

Node1.Node2

Node1.Node2

Node1.Node2

ServerName.DatabaseName

192.168

Bob

code example:

select

CASE

...

i didn't see this thread, and started building my response before Jason posted the cross post info.

a Normal view is not materialized as data the way a table is;

views get...

edited to avoid crossposting the post as Jason suggested. see the original thread.

I might be misreading your requirement, but what i guess that was what i was trying to say....

you have access to the remote server, right?

if you do, then you can...

i see;

can't you go to the remote server, find the role that your user mydomainname\username is in, and then jsut add a SQL login to the same role?

then that logon...

Eric can you show us the proc text itself, and maybe post the execution plan of the proc when it runs? that would give us the critical diagnostic info, i...

Jeff Moden (1/7/2010)

---

If it's a fixed field (no delimiters, each column a given width), then I just import into a single column flat table and do a simple substring split....

the trick is to use a combination of dateadd and datediff, here's sme examples of some firsts and lasts; to apply the logic to a specific daye, like "what...