Viewing 15 posts - 6,241 through 6,255 (of 6,395 total)
can you do a case on the set line of an update? never tried it myself
update table1
set col1 = col2
where col2 in ( select case when ISNUMERIC(col2) = 1...
October 27, 2011 at 9:23 am
can you send the results of the command sp_helpfile issued under the original db and we can build a script to do this for you
October 27, 2011 at 9:07 am
i dont want to change the procs.
i just want them to be able to see one particular job out of the list of jobs and have the ability to start...
October 27, 2011 at 7:49 am
Thats not a problem
But I want them to be able to start the job via the job's section under SQL agent in SSMS
October 27, 2011 at 7:25 am
Cheers BT
I have resorted to just doing * in the LDAP as we wanted the whole LDAP path to test a couple of changes to out VBS login script which...
October 27, 2011 at 2:01 am
maybe this will help
declare @nRows int
set @nRows = ##################################
declare @resultstable
(database_idint
,objectnamesysname null
,indexnamesysname null
,cache_kbbigint
,free_bytesbigint
,size_kbbigint null
,filegroupsysname null
,indidint null
,dirty_kbbigint null
,schema_namesysnamenull
,user_namesysnamenull
)
declare@databases table
(database_idint
,namesysname null
,idint identity
)
insertinto @databases (database_id, name)
selectdatabase_id, name
fromsys.databases
whereuser_access <> 1-- NOT SINGLE USER
andstate =...
October 26, 2011 at 9:55 am
no that wont work for your estate then as its only anything which can be controlled via group policy that will get lock pages in memory set.
unsure on anything else...
October 25, 2011 at 9:09 am
are all your SQL servers in one OU within active directory?
if so you could create a GP to enable it at the OU level, you can specify the list of...
October 25, 2011 at 8:51 am
have you run through the reporting services configuration wizard to create the reporting services databases and URL's etc?
October 21, 2011 at 2:15 am
I think I may have found the "cause" of this. One of the web apps we have uses encryption to store the passwords of registered users into the database.
Unsure...
October 20, 2011 at 5:29 am
Suresh B. (10/20/2011)
Try this.
USE testingGO
declare@MyEmailString varchar(MAX)
select@MyEmailString = coalesce(@MyEmailString + ';', '') + coalesce(useremail, '')
fromtesting.dbo.users
EXEC msdb.dbo.sp_send_dbmail @profile_name='test',
@recipients=@myEmailString,
@subject='Test message',
@body='testing testing'
Don't use GO after declaring a variable.
Good point Suresh, I didn't notice that....
October 20, 2011 at 4:32 am
noticed that you want a 0 for the second IsVoid, in that case put a "case" statement around isvoid in the select and say if it is 1 then 0,...
October 20, 2011 at 4:01 am
you just want to get everything where isvoid is 0 and the transid = transid
simple select statement
select col1, col2, col3 from tab1 where col1 = VALUE and col2 = VALUE...
October 20, 2011 at 3:58 am
please can you display how you want the results to look like
should the query return 4 rows for 200501, 0 for 200510 and 1 for 200525 etc
October 20, 2011 at 3:46 am
What is the collation of the server / database you are using?
It may be a simple thing as if you have a case sensitive (CS) collation, you have declared the...
October 20, 2011 at 3:19 am
Viewing 15 posts - 6,241 through 6,255 (of 6,395 total)