Topics
Started by
Posts
Last post
Hi, I am trying to write a script which will go through several databases and shrink their log. I …
7 replies
--this is perfect and it works declare @object sysname,@sql varchar(100) set @object = 'p_adv_perso…
6 replies
CREATE PROCEDURE [dbo].[ABCCDE] (@inputparam varchar(3)) AS SELECT DISTINCT desc as depdesc, Table…
12 replies
Hi All, I have a sql table contains Active Directory User data. This table contains First name, Las…
2 replies
How would you export a list of users and their permissions to a T-SQL script? I'd like to store thi…
2 replies
is there a way to find when was the database last updated time though i dont have any kind of trigg…
4 replies
Greetings people, I have racked my brain trying to come up with a simple query that will return a s…
3 replies
I am attempting to run a SQL transaction on two different servers. When I delete records in the fi…
3 replies
Ps: If you don't care about the background info, just look at the code... I have one table with bui…
1 replies
Why doesn't the below query show sysconstraints as an output? select * from sysobjects where name l…
6 replies
Ive been asked to produce a recordset in sql2000 :angry: and i would normally use the row_number fu…
8 replies
Hi all... REsident newbie here... I am trying to check four variables for NULL values. Is there an…
7 replies
I am trying to join two tables. The columns have to do with access codes. Table 1 defines the acc…
10 replies
Hi can we have an alternative of CStr(Format([InvoiceDate],"dd-mmm-yyyy")) in SQL Many Thanks ....
6 replies
Hi folks I need to derive a measure using a value from the current record, and another value from a…
15 replies
Viewing 15 topics - 7,201 through 7,215 (of 12,234 total)
You must be logged in to create new topics.