|
|
-
|
|
Hi,
Do you know when you restore the database it persist Single mode Access and CDC (Change Data Capture) configuration?
No. It will restore to default
User Access mode to Multiple
CDC : Disable.......
|
|
-
15
Liked
| 12
Learned
| 8
Comments
|
|
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
|
-
|
|
RSConfig.exe is used to define the connection properties from the SSRS instance to the Report Server database;
RSKeyMgmt.exe performs encryption key operations and scale-out deployment setup;
RS.exe runs Report Server Script files that can perfo......
|
|
-
|
|
You may read earlier post to add transactional publication in replication here http://beyondrelational.com/justlearned/posts/730/adding-the-transactional-publication-in-replication-sql-server.aspx, here how can we add a transactional pull subscriptions ......
|
|
-
|
|
To write the variable content to a file from sql server, we can use xp_cmdshell
Example
DECLARE @cmd sysname, @var sysname
SET @var = 'Hello world'
SET @cmd = 'echo ' + @var + ' > myfile.txt'
EXEC master..xp_cmdshell @cmd......
|
|
-
|
|
This is a real bug I first introduced in my SP and then spent two rounds before fixing, so I thought I'd post it.
I had the following code in my SP
[code]
declare @Log_no int
EXECUTE get_unique_key2 'K_GST_ACTV', @NumberOut = @Log_no OUTPUT;
......
|
|
-
|
|
If you want to use Some data from other server or same server after some ETL work then use SSIS package as DataSource for SSRS report. But the question is how?
Create datasource in SSRS and give the path of Package in Connection string as like
-f ......
|
|
-
|
|
Microsoft announced that SQL Server ODBC Driver for Linux will be available along with next version of SQL Server 2012 at Pass Summit 2011.......
|
|
-
|
|
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this ......
|
|
-
|
|
Here is the script to get details of current activities in all sessions in SQL Server
[code]
SELECT
[Session ID] = s.session_id,
[User Process] = CONVERT(CHAR(1), s.is_user_process),
[Login] = s.login_name,
[Database] = ISNULL(db_name(p.dbid)......
|
|