Search results for query: *

Hi, In SQL 2008 how can we notify connected client when there is update on perticular or all tables data. including which table's data updated through which client... I read that this can be done using Policy based management as SSNS has been removed from SQL 2008... but I can see table Facet...

Hi Guys, Below is the link of the question posted on MSDN SQL Forum. Question posted is about SQL Agents behaviour when changed system calendar date to backward. I could not get proper forum for SQL Server Agent related queries, I am sure could get direction from this forum...

Hi All, Here i have faced a different problem. I have a procedure to grant the execute permission on each procedure of all database to Execute Role. This procedure is working fine from QA, When scheduled it to run through job it is failing with the below message in job output file. Msg 913...

Not sure anybody else is aware of this, but to those who dont aware of this tricky method of generating script of SQL object like Tables, Views, Procedures, Functions. To generate the script for objects such as Procedures, tables and views I used to follow following steps . . Right Click on...

Here are some of the existing Old puzzles to keep all together . .:-D With my best wishes . . . Microsoft SQL Server:Programming Forum SQL puzzle for everyone (thread183-979475) by ESquared A SQL Puzzle (thread183-1043452) by Maswien SQL Puzzle: (Yelworcm's UDF)...

Hi Guys! While writing vb programm it is not neccesarry to add line number to each line. I have observed some of programmer use to add line number in theire programms. I think this practice helps them to navigate theire programms also we can jump to any line using 'goto <Line Number>'...

Hi! I have following query. Select a.* From Table1 a where not exist ( select * from Table2 b where a.col1 = b.col1 and a.col2 = b.col2 ) I want to get rid of WHERE clause. Is there a way to use join (Inner/outer) to retrieve the same result as above...

Hi All! Here is my requirement: I have one ASP Page at server, which reads values from parameters and write to a text file on server. Now I am Calling this ASP page with POST method like (http://localhost/MyWeb/WriteTxt.asp?FileName=EmpDetail.txt&Content=This+is+test+file) But this...

Can I use "Exec sp_MySP" in SQL Query box of Data Transform Task's Source Tab? When I use "Select * from tbl_MyTable" it works FINE, but I want to use result from one of my Stored procedures. I tried to use "Exec sp_MySP", it thrown an error like "INVALID POINTER". I AM SURE YOU HAVE A...