Topics
Started by
Posts
Last post
i have setup a filestream share and enabled it for streaming, and gave it a share name: \\myPC\MSSQ…
1 replies
Hi Guys.. I have to change the physical file name of Databse so should i have to detach DB chance …
9 replies
I have a couple of .xlsx files I am trying to import to sql server 2008R2 db table using SSIS. I se…
1 replies
how to restrict access to user at runtime to SPs having DML statement . some SPs may only have SELE…
6 replies
declare @tbl table(stdate datetime) insert @tbl select '12-31-2011' declare @date datetime set @dat…
5 replies
Hi I am designing a database for travel application, it consist Hotel,Flight,Package,Transfers,Cars…
40 replies
Hi everyone, We are in the process of enabling RCSI on our operational data store databases in SQL …
6 replies
ALTER PROCEDURE [dbo].[spGetDecryptDataTes] ( @caseid varchar(max) ) AS BEGIN DECLARE @hexstr v…
6 replies
I'm trying to write a stored procedure using a pivot table and I can't seem to wrap my head around …
15 replies
After migrating to SQL 2008 from SQL 2005 we are getting random Time out expired errors. "Timeout e…
6 replies
At this point I am not able/ready to upgrade my packages, but I need to run them on a SQL 2008 serv…
3 replies
Hi everybody, thanks in advance for your answers. Hey i'm really just new as a DBA but definitely s…
23 replies
When I run the following: exec master.dbo.xp_fileexist @filePath I always get 0,0,0. The @filePath…
3 replies
I'm trying to create a linked server to a DB2 database on AS400. However, I'm not able to run queri…
31 replies
Need help in pivot and sp_transform . I have a stored proc to calculate the no of people contacted …
12 replies
Viewing 15 topics - 19,981 through 19,995 (of 30,188 total)
You must be logged in to create new topics.