Viewing 12 posts - 31 through 42 (of 42 total)
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.
July 26, 2004 at 3:51 am
Strange question to have here since this is about how Crystal Report work and not about SQL. If not working with CR you just...
July 26, 2004 at 3:33 am
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
July 23, 2004 at 10:14 am
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...
July 23, 2004 at 6:54 am
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...
July 23, 2004 at 6:38 am
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:
June 28, 2004 at 2:42 am
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...
February 9, 2004 at 6:48 am
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...
July 24, 2003 at 7:17 am
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...
July 24, 2003 at 5:56 am
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:
July 24, 2003 at 4:56 am
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...
July 14, 2003 at 12:58 pm
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...
May 7, 2003 at 9:49 am
Viewing 12 posts - 31 through 42 (of 42 total)