If your are NOT using a sysadmin login, wich permissions do you need to run DBCC showfilestats?

I tried and it worked. I started first the backup an then started te shrink operation and all went well.

UMG Developer (1/5/2011)

As long as you don't mind incorrect results:

DECLARE @inputValue NVARCHAR(20)

DECLARE @student TABLE

(Id INT PRIMARY KEY IDENTITY(1,1),

StudentName NVARCHAR(50),

StudentResult INT)

INSERT INTO...

To complicated. Yo can solve it using CHARINDEX:

DECLARE @inputValue NVARCHAR(20)

DECLARE @student TABLE

(Id INT PRIMARY KEY IDENTITY(1,1),

StudentName NVARCHAR(50),

StudentResult INT)

INSERT INTO @student

VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99)

--Select 1

SET @inputValue = 'Hardy'

SELECT...

Please explain me about the variable $location. It is used in the line $webclient.UploadFile($uri, $location) to send the file to a FTP server, but $location is never initialized nor populated.

Alberto

------

My wife should read this! about the black and white thing and getting more tolerant. Shame she doesn't read English (I'm in Peru). But I will make time to translate...

I'm Triyng to autogrowth a log file. A created a DB witn one table with a couple of char 8000 fields, inserted many, many rows. But the Registry never gets...

To use TVP in SQL 2008 you first need to create a UDT based on the data type Table. I'm not sure if what youre trying to do is possible.

Here's...

I ended up with a mixed solution. I find it simple compared with those you proposed:

Declare @Path varchar(256)

declare @myquery varchar(1000)

Set @Path = 'C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'

set @myquery = 'dir...

well, this time is a poll. Please tell me if I'm doin'g wrong

You have two servers, local and remote. The remote server (or instance) must be a linked server:

From the current server write this:

SELECT a.Filed1, b.Field2

FROM LocalTable a

JOIN LinkedServer.OneDB.dbo.RemoteTable b

...

ah! I forgot to say that the scripts work for SQL 2005/2008

Here you have a couple of scripts that show you where are the objects:

TABLES:

SELECT

t.name AS [Table],

s.name AS [Schema],

ds.name AS [FileGroup]

FROM

sys.tables AS t

INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id

INNER...

Great trick that one with OPENROWSET. Very useful. I used to crete a temp table an then populated it with the result of a the system sp, but with this...

This is the one, promise. Sorry for the inconvenience

SET XACT_ABORT ON

BEGIN TRY

BEGIN TRAN

CREATE CLUSTERED INDEX ix_TableA_Transfer ON tableA (id) ON [OtherFileGroup]

COMMIT

END TRY

BEGIN CATCH

ROLLBACK

END CATCH