Viewing 15 posts - 4,201 through 4,215 (of 6,401 total)
You have RTM, SP and CU's in SQL.
The RTM is the first release which is ready to manufacture / market (forget the actual term), then MS release CU's (cumulative updates),...
July 24, 2012 at 3:08 am
Many different ways
1. Right click the login, select script login as, then create to new query window
2. Google "sp_help_revlogin"
3. SSIS Transfer logins task
4. Manually recreate them on the second server
Also...
July 24, 2012 at 3:02 am
I would recommend reading chapter 3 of the Accidental DBA Guide (link in my signature below).
July 24, 2012 at 12:43 am
USE MASTER
GO
EXEC sp_resetstatus '<databasename>'
GO
ALTER DATABASE <databasename> SET EMERGENCY
GO
ALTER DATABASE <databasename> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB (<databasename>, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE <databasename> SET MULTI_USER
GO
Or restore the database from a backup and apply...
July 23, 2012 at 7:16 am
DBCC DROPCLEANBUFFERS - Removes all clean buffers from the buffer pool.
DBCC FREESESSIONCACHE - Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
July 23, 2012 at 6:48 am
Yeah thats by design, as the retention period has expired and therefore SQL will delete the file even if it hasn't been copied to the secondary.
Typically in this situation where...
July 23, 2012 at 6:47 am
But be sure you dont run that on a production server, unless you can live with the performance bottleneck while SQL rebuilds the cache.
July 23, 2012 at 6:25 am
Something like this?
SELECT
TD.*
FROM
[#TransactionDetail] TD
INNER JOIN
#Version V
ON
TD.VersionID = V.VersionName
WHERE
TD.PERIOD >= V.StartMonth
AND
TD.PERIOD < V.EndMonth
AND
V.IsActive = 1
If not, based on the sample data you provided, what should be the...
July 23, 2012 at 6:21 am
Are the system databases in the default location or have they been moved to a different drive than the SQL binaries?
July 23, 2012 at 6:14 am
Hi
Welcome to SSC.
Would you be so kind as to read the second link in my signature below on posting code and data for the best help?
With the information you provide...
July 23, 2012 at 6:02 am
No it doesnt as technically its 1 row of data so it displays it as 1 row.
If you change the query output to text you will see it with the...
July 23, 2012 at 5:57 am
A simple concatination will do the trick adding in CHAR(10) + CHAR(13) for CR & LF
declare @table table (ColA char(1),ColB char(4))
insert into @table values ('A','The'),('B','iss'),('C','uout')
declare @variable nvarchar(max) = ''
select @variable...
July 23, 2012 at 5:49 am
Run DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS and post the results.
July 23, 2012 at 5:41 am
Why nolock? Do you know the consequences of using that hint?
Also if you need to use nolock make sure its WITH (NOLOCK) and not just (NOLOCK)
July 23, 2012 at 5:33 am
I've only found one topic on this, but it said it is OK to delete from sysssislog manually
July 23, 2012 at 5:27 am
Viewing 15 posts - 4,201 through 4,215 (of 6,401 total)