Topics
Started by
Posts
Last post
Hi, What is the best method to copy everything (including jobs, maintenance plan, alerts) to differ…
4 replies
While we were trying to purge the data in our SQL Standard database files ,the rows are not getting…
8 replies
Hi Friends, one of my user not able to access SQL server via windows authentication. however he has…
10 replies
So I have a logon trigger in place and it's working fine but I wanted to put in an alert to disable…
1 replies
Hi I am having a database whose size is around 10 GB. 1) If i shrink database using DBCC shrinkdata…
4 replies
In SQL 2005, is there a way to send an file as an read only. I tested with an Excel file and its pr…
1 replies
Dear All, I wanted to create a job in SQL which would automatically shrink a Transactional log file…
5 replies
Hello, Please can anyone help with a script or SP that can help determine when databases where last…
2 replies
Hi all, From a best practice point of view I know that database log files shouldn't be larger that …
5 replies
Hi guys, I'm running an openrowset command in SSMS on my machine which is 64 bit. select * from Ope…
14 replies
Hi everyone I hope someone can help I have the following query which uses Row_Number WITH A1 as ( S…
2 replies
Hi Guys, I am developing one automation tool for data migration from one table to other table, here…
4 replies
Given the phrase "A,b,B,a,c,b" is there a way to use my REPLACE keyword a return the string: 103!3@…
1 replies
Hi, has anyone seen where a delete has not committed and while waiting on the commit the user creat…
6 replies
Hi, I am using a case statement to define what output should be given based on a date in a varchar …
7 replies
Viewing 15 topics - 6,481 through 6,495 (of 30,225 total)
You must be logged in to create new topics.