Topics
Started by
Posts
Last post
I have the following query that works just fine: SELECT [fielda] FROM TableName I want to be able t…
3 replies
Hello... I am in the process of cleaning up some database records. This is a yearly purge type of …
7 replies
Greetings all. I'm a new DBA. I have a background in database design, just little experience on th…
4 replies
In the middle of a large stored procedure I have a working SELECT (see SELECT 01 below) which at a …
3 replies
All, Been trying to setup service broker as an async way of doing data level auditing. This is from…
14 replies
I have an XML file I want to transform into a table. The file I have looks something like this: (Ca…
10 replies
Hi there, I am trying to create DB diagrams in SSMS. The DB is from sql server 2000 i.e. its compat…
2 replies
Hi all! Is there a way to alter system stored procedures in SQL Server 2K5? When we try to run the …
6 replies
I've been given the task of rewriting this report and the guy before me used a bunch of ugly virtua…
15 replies
Hi All, What I am wanting is a trigger that runs the exec email code, if there is an error to email…
5 replies
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test CREATE TABLE #test (Descr Varchar(100)…
21 replies
Hello all, I have a weird problem I need help on. I'm developing on local SQL Server 2005 Express d…
2 replies
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=2;Database=E:\test.xls;…
10 replies
Hello, Is there a way for me to determine when a certain field gets a null value? This field is giv…
9 replies
Hello, I have a Schema by name "Common" in which I want a set of users "user1, user2, user3" to hav…
3 replies
Viewing 15 topics - 7,111 through 7,125 (of 10,974 total)
You must be logged in to create new topics.