 |
|
SQL Product Highlight
Idera - SQL safe backup
SQL Server backup compression with network fault tolerance and zero impact encryption
- Fast, compressed & encrypted SQL backup and restore
- SQL Server backup compression of 95%
- At least 50% faster than native SQL backups
Learn more!
Questions
|
Changing Database Collation
Hi: I have an issue and I am hoping that you can point me in the right direction. SQL was installed using "Latin_General_C1_AS" and a production database used by an application was installed and created using on the same.
|
asked 5/23/2013 8:52:14 AM by Liz 5 answers |
|
Generating Usage Logs
I'm having trouble creating the SWL script to allow me to run the reports below at any given time. I know that some of data requested can be generated by using SQL Profiler or C2 audit, Event logs and the sys.login_token, sp_who. Thanks in
|
asked 5/23/2013 8:47:04 AM by Dexter 0 answers |
|
install sql serrver 2008 using config file thru CMD
hi... i am using config file for installation thru cmd .... any parameters should we change in config file if yes please let me know Regards Sandeep
|
asked 5/21/2013 9:49:03 PM by sandeep 0 answers |
|
how many users for different types of editons in sql server
Hi There are different types of editions in sql server express edition enterprise edition developer standard editon work group edition i want to know how many instances ican we install for above editions and no of users
|
asked 5/21/2013 9:38:48 PM by sandeep 2 answers |
|
Syntax error near '"' in the full-text search condition
|
asked 5/21/2013 5:05:21 AM by supraja 0 answers |
|
use UserName as parameter to report
Hi! I want to limit the access to one report. I have too many users, that's why creation reports fot each user and security support is time-consuming. Can I create global parameter equals to the username and acording this parameter the user will see only
|
asked 5/20/2013 9:30:24 AM by Tanya 0 answers |
|
SSRS Caching Configuration
I'm developing a Report on Stock Exchange market.The Stock Market opens at 10AM and gets closed at 6PM.The Data is highly volatile/changable from 10AM to Evening 6PM,but after 6PM upto next morning 10AM there is not absolute changes in the Data. Requirem
|
asked 5/20/2013 8:47:05 AM by Shovan Mukherjee 0 answers |
|
Junior DBA
Hello, I am new to this site and the profession itself. I just finished a database management degree program and I have an interview this coming tueday. So I need an advice how to prepare my self for a junior DBA position. The second advice I need is a
|
asked 5/19/2013 11:07:35 PM by Wubeshet 0 answers |
|
which transformations comes under synchronous and which are comes under asynchronous and why?
|
asked 5/19/2013 10:06:09 PM by Vani D 2 answers |
|
Proactive caching failed to process data when data changed in tracking table. It's working fine in dev and uat but failed in Prod server . Server ,:sql server 2008 r2 version 10.50.2500.0 .
|
asked 5/18/2013 8:58:33 PM by shenid 0 answers |
|
To avoid repeatation on string
In a string for example(abc,bbc,bcc,abc,bbc) how to remove a dulpicate string like (abc,bbc) using functions or sub string. i need the exact answer of (abc,bbc,bcc). Please give a idea for this Question. thanking you
|
asked 5/18/2013 1:12:34 AM by Antony felix 0 answers |
|
one article per publication vs multiple articles in one publication
Hi all, We are using push transaction replication and distributor is on its own server in a SQL 2008 env. Within a user db, I normally set up one publication for all articles I want to publish in that db. But I also see o
|
asked 5/16/2013 11:59:11 PM by OceanDeep 0 answers |
|
Repliaction of Heterozenous ? so please help to me with screen shots step by step
hii please how to configure Heterozenous Replication .and how to create oracle publisher in oracle.i am using sql server 2008r2 .
|
asked 5/16/2013 12:03:33 PM by RAJA 0 answers |
|
SSIS - Data convertion failed
Hi Folks, I am trying to load csv file into SQL Server table. But I am facing the below error: Error: Data conversion failed. The data conversion for column "xxxx_ID" returned status value 2 and status text "The value could not be converted because of&n
|
asked 5/16/2013 3:39:53 AM by RamiReddy 1 answers |
|
Creating stored procedure in system database Master to perform backup and restore operations? Pros and Cons?
Hi, I wanted to check the cons of creating stored procedures in system database Master for running backup and restore operations, as the previous DBA who was here has done that. There are other procedures that are configured in Master database including
|
asked 5/15/2013 10:22:43 AM by Malini Sethi 1 answers |
|
Access SQL Server 2012 Database from 2 different locations connected using VPN
Hello, I want to access a database simultaneously in 2 different locations(approx. 10 miles diff.). We have 2 windows 2008 licensed servers and also have 2 Microsoft Sql Server 2012 (licensed) in each locations. We also have established VPN connection wi
|
asked 5/15/2013 4:43:30 AM by Abdul Anoop 0 answers |
|
trigger help
I have a strange requirement. This is a code issue but i am looking for a work around from daatabase perspective. I have a table that has a foreign key relation ship and it has duplicate values. Now I need a trigger to suppress inserts if a couple of colu
|
asked 5/14/2013 12:27:20 PM by Sapen 1 answers |
|
Droped Table status in SQL Server.
Hi all, Some one has Dropped a Important table from my databse as it is shared DB. It just happened one day Before. I want to know the time and date and the username who dropped the table. and Is there anyway to recover back that table without using l
|
asked 5/14/2013 7:05:30 AM by Satishchandra Vishwakarma 0 answers |
|
Related to Stored Procedure & User Defined Function's Pre-Compiled Concepts
Hi All, Need Help on Bellow Mentioned Doubts Q 1: What happens when we Submit / Execute the a Sql Statement (For Ex : select * from person ) i.e. what are the execution steps taken by the Sql Server behind the Scene. Q 2 : What is Pre-Compiled Concept
|
asked 5/14/2013 2:53:25 AM by AnilVanjre 0 answers |
|
SQL Error log size increasing drastically
Hi, I have SQL2008R2 installed in my IBM server, recently i have identified that SQL Errorlog and SQLDUMPER_ERRORLOG size increasingly drastically. I checked in C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log and
|
asked 5/14/2013 1:04:56 AM by shahniaz 0 answers |
|
privacy | disclaimer | copyright | advertise | about authors | contribute | feedback | giveaways | user groups Some names and products listed are the registered trademarks of their respective owners. Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com |