solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Idera - SQL compliance manager

Low-impact SQL Server auditing of all user activity and data changes

Real time auditing
Flexible collection filters
Customizable alerts on suspect activity

Learn more!

Questions

Ask a SQL Server Question

[<< Prev] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next >>]

How to send excel reports in an email using SSIS	asked 3/6/2013 7:34:05 AM by Noma 0 answers

SQL Server Content censorship Hi Champs, We have little strange requirement in a case of SharePoint where backend is SQL. Users in social features of SharePoint shout not be able use offensive words in comments, newsfeeds, conversations, reply etc, The system m	asked 3/6/2013 4:11:29 AM by Inder 0 answers

auto-complete in access 2007 Hi, i want to do auto complete in my testbox in access 2007.i want to use this either in textbox or dropdown list incase a customer want to add more fields or prevent them from re-type the data..ive searched but cant find the correct answer to my problem	asked 3/6/2013 12:19:15 AM by Amena 0 answers

What are the assets types in sql server? Hi Team, I have been asked a question from Microsoft Team what are the assets type in SQL server or how many assets types are available in sql server? Please suggest Thanks Pradeept Singh	asked 3/6/2013 12:08:24 AM by PRADEEPT SINGH 0 answers

Databse inConsistencies and recovery HI, I am currently supporting sql2005 DB's across 1000 stores ( 1 DB for each store). Due to frequent power outages, the server shutdowns are happening quite often. Hence when the server comes back, the DB is reproting inconsitencesi. Hence the res	asked 3/6/2013 12:00:45 AM by Francis 0 answers

Export a report with sub reports from SSIS 2008 I have the vbscript which exports to the original report and that works fine. The pdf report is produced but the sub report does not show. The report and sub report are designed in Cyrstal 11 format and work correctly when refreshed in Crystal. What do I	asked 3/5/2013 4:19:09 PM by R Gohill 0 answers

Conflict in Peer-to-Peer Replication We have setup peer to peer replication between Server A and Server B. When some conflict occurs Server B wins and server A lose (i.e. Server B overwrite Server A). But we want server A data overwrites on Server B when some conflict occures. Server A has o	asked 3/5/2013 6:49:42 AM by nipul 0 answers

Any ideas on why the SSRS report would run so slow in this particular environment? I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. This is not	asked 3/5/2013 5:49:00 AM by limitha 1 answers

sql pls explain the stored procedure concept breifely?	asked 3/4/2013 5:55:46 AM by elancheran 1 answers

passing dob from 3 drop down lists to the database how do i pass the dob which i take from 3 seperate drop down lists to ms sql server databasa? thanks for any help.	asked 3/3/2013 7:52:17 PM by lazen 2 answers

how to deploy ssrs in production environment? Hi everybody! i am new on this. i have been doing some reports on SSRS using (BIDS) in my development environment and all works fine in my test server deploying in the native mode server and sharepoint integrated mode server too. So my question is how	asked 3/2/2013 1:55:08 PM by Dea 1 answers

Database Development select Rpt_cat.Cat_Report,sum(isnull(MTodaySales.TY,0)) as MTY,sum(isnull(MLYSales.LY,0)) as MLY from (SELECT Cat_Desc, Cat_Report, Cat_Code, Cat_Dept_Code FROM T_MIS_Mas_Category where Cat_Dept_Code	asked 3/2/2013 5:12:37 AM by jeevan 0 answers

SSRS - Copying the URL Link of a Rendered Report Hello All, I'm using SSRS 2008 R2. After rendering a report, I want to be able to copy the URL link in the Browser's Address Bar of the rendered report and email that link to someone giving them the ability to also view that report without having to	asked 3/1/2013 5:35:31 PM by Ronnie 1 answers

SSRS rendering a report with custom code twice Hi folks Thanks for all the activity here, really helps a lot and a lot of people... I have a report which shows some records that have an active/inactive flag (datatype = BIT). I have another report which has a custom in it, which is called whenever us	asked 3/1/2013 11:35:31 AM by Alin 0 answers

Role based access implementation in Sqlserver Could you please let me know the pros and cons of Role based access implementation in SQLserver 2008 and 2012.Please provide evidences with any referral links to your information.	asked 2/27/2013 3:20:04 PM by raja 0 answers

case studies for making tempdb as default db for all logins in server Hi,Do we have any case studies or standard links or referrals that says "DO It" or "DON'T DO IT".tempdb as default db for all logins	asked 2/27/2013 1:54:26 PM by raja 1 answers

Problem showing/splitting data on a single report page I'm unsure at this point how to present the problem I'm having developing a requested report with SSRS. The db View that I've been given to work with, along with the requested formatting of the report itself, are static so I'm restricted as far as what	asked 2/27/2013 11:49:12 AM by Patrick 0 answers

SQL 2008 R2 Problem with TempDB when running SSIS Hi I have a problem with some SSIS packages. I use SSIS to extract data from a server that is hosted by someone else. The query extracts about 2 000 000 rows and it has been running for several years. When the source server was upgraded fr	asked 2/27/2013 4:07:59 AM by chrand 1 answers

Restore failed for Server 'SERVERNAME'. (Microsoft.SqlServer.SmoExtended) Possible schema corruption. Run DBCC CHECKCATALOG. (.Net SqlClient Data Provider). Can anyone help me resolve this issue as i can't restore my backup and that's the only bak i have. thank you in advance.	asked 2/26/2013 6:14:07 PM by Paakwesi 1 answers

failed to create Integration project on BIDS I have installed SQL Server 2008 Develpoer Edition on the server.The server is working fine. When i was trying to create New Integration project in BIDS(SQL Server Business Inteligence Studio).It is failed with this error message "object reference not se	asked 2/26/2013 5:17:51 AM by GURUSHIDDAPPA 1 answers

[<< Prev] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next >>]

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen."

NEW! Top 5 hard-earned lessons of a DBA from Grant Fritchey & the DBA Team. Read it now

What grade do you think your SQL Servers get? Find out with Edgewood's Health Check consulting services.

Free SQL Server performance monitoring software! Improve performance by 65% today with IgniteFree.

SQL Server Data Tools - Got questions? Get the answers here!