Viewing 15 posts - 4,966 through 4,980 (of 7,185 total)
OK, then if you absolutely need to use a database function, you'll need to use an Execute SQL task to run it and get the result into a variable and...
November 4, 2011 at 9:52 am
You don't need to incur the expense of connecting to a database just to get the current date and time, and even if you do, you don't need a user...
November 4, 2011 at 9:27 am
If your users are attempting to see the new columns in SSMS, they need to refresh first before they can see them. This one has caught me out before!
John
November 4, 2011 at 9:08 am
Is the user defined function a SQL function? What parameter(s) does it take, if any? You'll need to connect to the database in order to evaluate it before...
November 4, 2011 at 9:03 am
Yes, you can have two foreign key constraints on tblWorkedHours - one referencing tblClients and one referencing tblTasks.
John
November 4, 2011 at 8:15 am
Can you not just leave the client column NULL in tblWorkedHours where there is no client involved?
John
November 4, 2011 at 7:01 am
Nithin
Can it be as simple as this:
SELECT TOP 1 * FROM MyTable
WHERE MyColumn > 4000
ORDER BY MyColumn ASC
John
November 4, 2011 at 6:53 am
If you run that code in a query window, you'll get the full output and you'll be able to see which database is causing the problem.
John
November 4, 2011 at 4:09 am
I think you'd be best investigating converting your variable to datetime and then using the DATEPART function. But, if you insist on doing it as above, something like this...
November 4, 2011 at 2:51 am
What do you mean by "offline back"? Why do you want to do it?
John
November 4, 2011 at 2:43 am
You need to find out which operation is taking more than 600 seconds to complete, and look at improving its performance.
John
November 4, 2011 at 2:23 am
I think you have three options, then:
(1) Do as Brian suggested, but then explicitly deny EXECUTE on all system stored procedures.
(2) Move your user-defined stored procedures to a different schema...
November 3, 2011 at 4:22 am
Because there should be no expectation that the results of a SELECT query will be ordered, whether the query is against a table or a view, and whether or not...
November 2, 2011 at 5:15 am
If you've got corrupt data in your database then I would recommend that you deal with that before anything else. Have a read about DBCC CHECKDB if you haven't...
November 2, 2011 at 2:42 am
Ninja's_RGR'us (11/1/2011)
Edit YUP.
There's no point in putting the columns in the correct order. You do that in the select statements.
SQL will order those...
November 1, 2011 at 5:41 am
Viewing 15 posts - 4,966 through 4,980 (of 7,185 total)