Viewing 15 posts - 4,921 through 4,935 (of 6,400 total)
When a database is attached to SQL, the sqlserver.exe locks the files so that it has exclusive access to the files, the only way to backup databases via NetBackup without...
May 25, 2012 at 2:21 am
SQL 2000 is DTS not SSIS, are you sure its SQL 2000 or is it SQL2005/2008?
What coding issues are you facing?
Rebuild master just rebuilds the master database, but to be...
May 24, 2012 at 8:57 am
lookup the merge syntax in BOL or Google, its basically a fancy update/insert/delete combine statement, based on what you want, the main bits are the WHEN MATCHED and WHEN NOT...
May 24, 2012 at 8:53 am
the merge command will do what you need to do
when not matched by target = insert
when not matched by source = delete
when matched and target.col1 <> source.col1 or target.col2 <>...
May 24, 2012 at 8:40 am
JAZZ Master (5/24/2012)
anthony.green (5/24/2012)
Daniel Bowlin (5/24/2012)
anthony.green (5/24/2012)
Ray K (5/24/2012)
SQLRNNR (5/23/2012)
Revenant (5/23/2012)
tigerSurvivor
Foreigner
asylum
records
roadrunner (beep beep)
Wiley
Merrie Melodies
May 24, 2012 at 8:33 am
Daniel Bowlin (5/24/2012)
anthony.green (5/24/2012)
Ray K (5/24/2012)
SQLRNNR (5/23/2012)
Revenant (5/23/2012)
tigerSurvivor
Foreigner
asylum
records
roadrunner (beep beep)
May 24, 2012 at 8:22 am
No problem, happy to help as always.
May 24, 2012 at 8:05 am
Only SQL authentication accounts become "orphaned" this is due to the SID's being different on Server1 to Server2. The exception to this is if the SQL accounts have been...
May 24, 2012 at 8:04 am
It's a seperate check box on the SQL Server installation, so you will need the SQL Server media to install BIDS. Its a completly seperate program from SSMS.
The installation...
May 24, 2012 at 8:02 am
When you install SQL you have the option to install what we call BIDS (business intelligence development studio), if you dont have it installed, just simply run through the media...
May 24, 2012 at 7:55 am
You would need to build in a dynamic date call something like the below
declare @datestamp nvarchar(30), @cmd nvarchar(max)
set @datestamp = REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR,CURRENT_TIMESTAMP,120),'-',''),':',''),' ','')
set @cmd = 'BACKUP LOG db1 TO DISK =...
May 24, 2012 at 7:52 am
Something like this
DECLARE @toemail varchar(150), @jobname nvarchar(150), @short_desc nvarchar(150)
DECLARE email_cursor CURSOR FOR SELECT email, RTRIM(Job_name), RTRIM(short_desc) FROM vw_expiring_jobs
OPEN email_cursor
FETCH NEXT FROM email_cursor
INTO @toemail, @jobname, @short_desc
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @toemail
DECLARE @body...
May 24, 2012 at 7:42 am
What is the business requirements on changing the server level collation? Is there a specific problem you are attempting to fix?
Rebuilding the master DB will result in all the...
May 24, 2012 at 7:39 am
They are stored on the machine used to develop the solution. If you have something like TFS or a source control environment, you could see if the person uploaded...
May 24, 2012 at 7:33 am
Viewing 15 posts - 4,921 through 4,935 (of 6,400 total)