either change the column so that its the same as the original column being imported, or convert the value on the insert, but make sure that when you convert that...

there is a tool from Quest which is freeware and allows you to scan the network, but you need to know IP ranges, what you think default passwords would be,...

In all of my professional experience, we as DBA's have always been given a blank bit of tin, we install the OS, SQL, patches etc.

The only exception to this is...

You would want to do something along the lines of this

--CREATE A NEW BLANK DATABASE

CREATE DATABASE [bcdata_restored] ON PRIMARY

( NAME = N'bcdata_restored', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\bcdata_restored.mdf'...

if you still post the results of sp_helpfile, i will build you a script which restores to a different database and location, that way you can play about with it...

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...

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

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...

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

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...

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 =...

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...

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...

have you run through the reporting services configuration wizard to create the reporting services databases and URL's etc?

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...