Topics
Started by
Posts
Last post
I am following a book called "Pro SQL Server 2008 Policy-Based Management". There is a section that…
7 replies
I need to insert new rows in a table that has a column for sequence number values (attrib_seq) for …
Anonymous
2 replies
By: Anonymous
Hi below is sample data for my issue. with data as ( select 'microsoft' as Name, '2013-08-01' as d…
20 replies
Given the following tables and data: declare @TextTable TABLE ( Acct int, TextDesc varchar(5…
5 replies
Hi, I have a linked server and a SQL job is running from the source server. The stored procedure wa…
7 replies
1) Some of our user DB's vary in Recovery Model, either Full or Simple. Is there anything to consid…
11 replies
Wrong place to post this I know but I couldn't find the appropriate forum. How do I add an image fr…
2 replies
Hi Friends , I have two table like log table and main table as below LOG TABLE IDPREVSTATUSCURR …
1 replies
I'm trying to make a minor adjustment to my backup stored procedure but I'm struggling to get the r…
8 replies
Hi! I inherited a SQL Serve 2008 R2 sp2 database maintenance (db reindex,checkdb etc) where the fir…
3 replies
Could any one explain the steps involved in database refreshment or any useful links relating to th…
1 replies
Hi there, I would like my result set to have one row for each patienid. We CAN lose the ledgertype …
8 replies
Hi, I have this sql SELECT r.dbPatID, t.PatientFirstName, t.patientlastname, r.dbstatusdesc, r.db…
6 replies
I know shrinking a database is not recommended but our management needs the precious disk space bac…
17 replies
We have the following code (dumbed down): SELECT Customer.CustomerId, Location.Description FROM Cu…
20 replies
Viewing 15 topics - 7,786 through 7,800 (of 30,225 total)
You must be logged in to create new topics.