DECLARE @sql varchar(200)

CREATE TABLE #t(db sysname, own sysname, tab sysname, Col sysname, Seq tinyint, PKName sysname)

SET @sql = PARSENAME(@TableName,3) + '.dbo.sp_pkeys ' + PARSENAME(@TableName,1) + ','...

quote:

---

After every full backup I automatically run these 2 commands to reclaim the space the TLog has allocated:

backup log DBName with truncate_only

DBCC...

Yes, every edition other than MSDE comes with the GUI utilities.

--Jonathan

You can use DMO to script out creation scripts for database objects. There are a myriad of ways to get the data into a local file, from passing it...

Sybase had TOP (and a synonym, FIRST) the last time I used it, several years ago. It did not have PERCENT or WITH TIES options, though.

--Jonathan

In ADO you've got the Number, SQLState, and NativeError properties of each error object. I typically use the SQLState when testing expected conditions in an error handling routine, as...

You're treating TEXTPTR() as static and it's not. Try this:

DECLARE @TextPointer varbinary(16)

DECLARE @ReplaceStr varchar(8000)

DECLARE @SearchStr varchar(8000)

DECLARE @DeleteLength int

DECLARE @OffSet int

 

SET @SearchStr = 'XXXX'

SET @ReplaceStr...

As you're wanting to truncate rather than round, I think cmore means:

SELECT ROUND(1,-2,1)*ROUND(b,-2,1)

If the vales are an integer data type, you could also just do something...

Sorry; duplicate post. "Delete reply" still nonfunctional.

Edited by - Jonathan on 11/25/2003 1:44:33 PM

EXEC master..xp_regread 'HKEY_LOCAL_MACHINE','Software\Microsoft\MSSQLServer\MSSQLServer','Backupdirectory'

--Jonathan

As there are no table constraints other than PRIMARY KEY and FOREIGN KEY in SQL Server, I presume you mean a column CHECK constraint.

CREATE FUNCTION dbo.CntUser(@userid...

quote:

---

Will running transaction log backups every two hours WITH INIT, NOSKIP keep the transaction from growing too large?

---

November 25, 2003 at 8:58 am