Forum Replies Created
Viewing 15 posts - 11,386 through 11,400 (of 18,923 total)
-
RE: enabled job vs enabled schedule
Prove him wrong :
Create a new job.
SET it to run in 1 min.
and use the net send notify after completion.
Disable the job and see how it does not run.
Good...
-
RE: Free Space
RUN dbcc updateusage(0) with no_infomsgs
CLOSE EM
OPEN EM
See the correct results
. -
RE: How to write a check constraint
On a side note. The advantage of using a trigger for such validation is that you can return a custom error message. Something you couldn't do with the...
-
RE: How to write a check constraint
IF EXISTS (SELECT * FROM dbo.SysObjects WHERE XType = 'U' AND Name = 'tblDemo')DROP TABLE dbo.tblDemo
GO
CREATE TABLE dbo.tblDemo
(
Sitefk INT NOT NULL
, ContentGroupID INT NOT NULL CONSTRAINT DF_tblDemo_ContentGroupID DEFAULT
-
RE: Copying data form MS Access to SQL Server 2005
Insert into dbo.YourTable (a,b,c)SELECT a.a, a.b, a.cFROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders) AS a -
RE: enabled job vs enabled schedule
I can't confirm this and I have no place to test so I'll let others handle this one.
But as far as I know for a job to run, it must...
-
RE: How do you use a variable for the table name in SET IDENTITY_INSERT?
Lol... can't wait to see that
. -
RE: DBCC INDEXDEFRAG
As I already said, the order of the results changed because the query plan changed, which itself changed most likely because of the index defrag you ran.
You can see the...
-
RE: enabled job vs enabled schedule
No, the agent won't run a disabled job.
-
RE: Performance - too many indexes
I for one would like to have a link to that page
. -
RE: Limit of exec () and sp_executesql
Check this out :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=285646
Also if and estimation is enough for you, you can use the sysindexes tables :
SELECTO.Name
, MAX(i.rowcnt) AS RowCounts
-
RE: Strip off year from date field
How does this work if the Birthdate for the current year is already passed???
-
RE: splitting a string
LMAOROTF.
Seriously, this is the kind of process you automate as much as possible, but in the end you always have to manually validate the results.
-
RE: How to get a list of user-defined stored procedures
SELECT NameFROM dbo.SysObjects
WHERE XType = 'P'
AND Status >= 0
ORDER BY Name
-
RE: return 1 row only with union all
It should look something like this :
CREATE FUNCTION dbo.FnName (@param AS int)
RETURNS TABLE
AS
RETURN SELECT Col1, Col2 FROM dbo.TableName where ColA = @param
GO
SELECT * FROM dbo.FnName(8)
GO
Viewing 15 posts - 11,386 through 11,400 (of 18,923 total)