5g or so. Only time the size matters is if you're doing a snapshot. Across a slow link it can take a while! You can always work around that issue....

No, detaching handles it through SQL so it all works fine. If the db is replicated you'll have to remove replication first. The alternative would be to add a new...

You could run a job that checked sysjobhistory. A simple job might just check for jobs that started that had been in progress more than an hour or so, a...

This works using 2000.80.532.0

Dim oServer As SQLDMO.SQLServer

Dim oDB As SQLDMO.Database2

Dim oFunc As SQLDMO.UserDefinedFunction

Set oServer = New SQLDMO.SQLServer

oServer.LoginSecure = True

oServer.Connect "higapp4"

Set oDB = oServer.Databases("Train01")

For Each oFunc In oDB.UserDefinedFunctions

...

Just type the name in, you don't have to pick from the list. Not all servers "advertise" their presence. On the other hand, you may have a connectivity issue about...

The answer is it depends. Im in favor of one login for data access and securing the application via NT group membership.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Do they have to create the SQL logins via the application? Or can they pre-exist. If they can one method I've used it create a very simple UI that allows...

Im confused - a proc that returns a recordset or you're looping through a recordset executing a proc for each row? In any case the simplest way I know is...

Try UserDefinedFunctions Collection of the database object - SQL2K only of course.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Locking is tricky. The reason the db is so "open" is to allow max scalability - ie concurrent users. While it takes getting used to, you need locking to maintain...

Hopefully we have MSDE users that can help you with the details. For security you have these options (with lots of sub options!):

-NT Authentication, just create a group called YourAppAuthorizedUsers,...

There is just no way to secure the schema. Even if you set your own SA password there is nothing to stop someone from stopping the service and just moving...

I dont disagree that a binary compare should be the fastest. Depending on the implementation of the collation certainly its going to be a few clock cycles slower and at...

I think for the reasons I mentioned earlier. Sometimes it's hard to find what you're looking for in BOL, especially if you're new to SQL and don't know what everything...

Cant speak for the rest, but I often quote BOL because 9 times out of 10 the person asking just hasn't known exactly where to look in BOL and it...