i always use SSIS, just set CopySchema to true and select all the constraints, etc you want to copy over

once in a while we have weird problems like this and most times it's in a database that has been around since SQL 7 and continually upgraded across different SQL...

can't remember all the feature differences but Oracle and SQL Server support a lot more features than MySQL. one reason is that both of them have extensions to SQL in...

it's not required but it can help

there was a blog post on MSDN a few years ago from one of the SQL 2005 dev's and if you search here, a...

had a bunch of these earlier in the year and last year

make sure you specifically set paging file size because in x64 windows the default size is wrong. second enable...

the encryption algorithm is very simple and has been around for years. we have a bunch of lookup db's and tables with server names, db names, logins, etc where apps...

i get the same thing. i created a trigger with the code below and have on row in the table i want to use as a blacklist.

we are getting ready...

NDA, we could tell you but then we'd have to kill you

dotnetrocks

Thayal Muhunthan (8/22/2008)

---

Question on CAL licences again ?

If we have 3 users accessing the SQL server using an third party application, do we calculate 3 or 1 CAL ?

More clearly,...

common sense would say that if you create a table that will hold thousands of rows you need an index or two

or my favorite, years ago we told devs to...

CAL's are the same

for the server license it's a few thousand $$$ for Windows and SQL

you can do CPU licensing but that's only if you have tens of thousands of...

pretty sure MS considers 1 CPU to be 1 socket and not a core

I think it was Oracle that tried the 1 core is 1CPu thing a few years ago...

we run sql standard with 2 quad core CPU's, x64 version

we only run enterprise x64 if we need clustering and for SQL if we absolutely need online indexing

you have to get your developers on it

in our case they called BEA and it's a known issue and no help. i think it also has something to do with...