Viewing 15 posts - 61 through 75 (of 280 total)
If my stored procedure invokes a SELECT, I'd normally just put it inside an INSERT clause, like so:
CREATE PROCEDURE myProc
AS BEGIN
SELECT [name]
...
September 4, 2012 at 10:52 am
Ask yourself why you are using the Enterprise edition version - is it for features like backup compression, TDE etc? What might break if you downgrade? Cross reference...
September 3, 2012 at 3:27 am
Is your Windows account a member of the Administrators group, and is the Administrators group a valid server login group with sysadmin permissions?
If so then log in using...
August 31, 2012 at 1:19 am
hoseam (8/31/2012)
CSN NAME LOCATION ...
August 31, 2012 at 1:11 am
GilaMonster (8/24/2012)
derek.colley (8/24/2012)
August 24, 2012 at 11:41 am
Good question, I thought there would be a limit but didn't know what it was. Guessed 1000 would be okay (overlooked the zero!), 8096 too many for a #table,...
August 23, 2012 at 2:42 am
You should always create your trace files server-side, since this places least load on the server. SQL Profiler is a client-side wrapper for a server-side process, as such the...
August 22, 2012 at 6:03 am
My (dirty) solution: Add a couple of REPLACEs at the end of your code, outside the loops:
SET @STR = REPLACE(@str,'nn','n')
SET @STR = REPLACE(@str,'nnn','n')
August 22, 2012 at 5:58 am
Well spotted!
In response to an email asking some questions about the script I posted, some more related scripts...
The first is short and enables you to create a dictionary of the...
August 15, 2012 at 12:42 pm
You've got the isolation level set to READ COMMITTED in your second (SELECT) transactions. So if they are trying to read data from tables locked for UPDATE (your first...
August 10, 2012 at 3:40 am
Usman Butt (8/10/2012)
I forgot that the same could be handled with DDL (LOGON) trigger as well 😉
Definitely not - the problem with FOR LOGON triggers is that if something happens...
August 10, 2012 at 3:27 am
REVERSE(1*REVERSE([Column] * 1))
Dwain - elegant but doesn't work for larger values. Example:
DECLARE @Foo VARCHAR(20)
SET @Foo = '00002432002000'
SET @Foo = REVERSE(1*REVERSE(@foo * 1))
PRINT
August 10, 2012 at 1:44 am
Database users are mapped to server logins (and vice versa). I'm afraid you will need a server login to associate a new database user with. The server level...
August 10, 2012 at 1:31 am
Should follow BODMAS, i.e. Boolean, Division, Multiplication, Addition, Subtraction.
August 10, 2012 at 1:26 am
If you don't have audit capability, here's my take on how to do it.
-- this sets up the table
CREATE TABLE loginAudit ( login_name VARCHAR(MAX), last_login_date DATETIME )
INSERT INTO...
August 10, 2012 at 1:24 am
Viewing 15 posts - 61 through 75 (of 280 total)