Hi!

Are the developers in a nt-group or individual logins (sql or nt)?

To be able to create or alter userdefined functions, users need to be, at least, db_ddladmin.

Strange question to have here since this is about how Crystal Report work and not about SQL. If not working with CR you just...

Hi!

There is a problem to use .RecordCount if the recordset does not contain all columns of a table, and don't ask me why it is like that

If there is something that hold the file and you try to backup your database "WITH INIT", it will give you the same error as you get now "Device offline...".

So...

The message "Device off-line or device off-line" indicates that something might hold the file that you are trying to write to. Proberly the file is still beeing removed when the...

I would geuess that the job is owned by 'sa', and the user that would like to kickstart the job is not.

They way to get around this is:

1. Change the owner...

When you run in QA you run below your own login wich is problably a member of "system administrator", because thats when you are able to run/execute jobs owned by...

Hi Linehand!

Wow, at the first glance of your question it looked quite simple to come up with a sulotion for you. But after creating your sampletables and reading the question...

Hi Dion!

You can store the result from a dynamic sql in a temporary table and return it to the user with a simple select on the temporary table. But you...

Hi Clerner!

Here is some more explanation on how to access flat files (i.e. txt) as tables in SQL Server.

First you need to add the directory where you keep your textfiles:

Hi WebPhil!

From what I've understood you want the menuitem that only have one underlying menyitem where the user have access to the menuitem but not the underlying menuitem, to show...

In my oppinion standars are very importent. I (among a couple of collegues) manage 500+ sql-servers. The servers that requier the most time from us are the ones that does...