Showing posts with label tells. Show all posts
Showing posts with label tells. Show all posts

Saturday, February 25, 2012

Autoincrementing file share

Hi all,
I'm really new at reporting services. I'm hoping someone can help.
I have a subscription that runs daily. The MSDN tells me
"AutoIncrement, the report server appends a timestamp or number to the file
name to distinguish it from existing files of the same name".
Currently the number is being appended to the file name daily, however I
would like the timestamp appended. Any ideas how to achieve this?
Thanks
DebbieSorry about the duplicate posts. I couldn't find the original one I posted.
Now that I have found it, I can't delete this one. >_<
Debbie
"Debbie" wrote:
> Hi all,
> I'm really new at reporting services. I'm hoping someone can help.
> I have a subscription that runs daily. The MSDN tells me
> "AutoIncrement, the report server appends a timestamp or number to the file
> name to distinguish it from existing files of the same name".
> Currently the number is being appended to the file name daily, however I
> would like the timestamp appended. Any ideas how to achieve this?
> Thanks
> Debbie
>

Friday, February 24, 2012

AutoGrow DB option

Hi all, what i really want to know is what actualy tells sql server to grow
the database, file, i found a post that says something about xmb size, what
can find no other impormation, So my question is what event promts sql to
autogrow its database file,
Thanks Andrew
Whenever a connection is executing a query where space needed to be allocated (read about extents in
Books Online), and there is not space in the database file (or files if that object is on a
filegroup constituted of several files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andrew bourne" <andrewbourne@.vardells.com> wrote in message
news:uYmvtb3ZFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi all, what i really want to know is what actualy tells sql server to grow the database, file, i
> found a post that says something about xmb size, what can find no other impormation, So my
> question is what event promts sql to autogrow its database file,
> Thanks Andrew
>

AutoGrow DB option

Hi all, what i really want to know is what actualy tells sql server to grow
the database, file, i found a post that says something about xmb size, what
can find no other impormation, So my question is what event promts sql to
autogrow its database file,
Thanks AndrewWhenever a connection is executing a query where space needed to be allocate
d (read about extents in
Books Online), and there is not space in the database file (or files if that
object is on a
filegroup constituted of several files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andrew bourne" <andrewbourne@.vardells.com> wrote in message
news:uYmvtb3ZFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi all, what i really want to know is what actualy tells sql server to gro
w the database, file, i
> found a post that says something about xmb size, what can find no other im
pormation, So my
> question is what event promts sql to autogrow its database file,
> Thanks Andrew
>

AutoGrow DB option

Hi all, what i really want to know is what actualy tells sql server to grow
the database, file, i found a post that says something about xmb size, what
can find no other impormation, So my question is what event promts sql to
autogrow its database file,
Thanks AndrewWhenever a connection is executing a query where space needed to be allocated (read about extents in
Books Online), and there is not space in the database file (or files if that object is on a
filegroup constituted of several files).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andrew bourne" <andrewbourne@.vardells.com> wrote in message
news:uYmvtb3ZFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi all, what i really want to know is what actualy tells sql server to grow the database, file, i
> found a post that says something about xmb size, what can find no other impormation, So my
> question is what event promts sql to autogrow its database file,
> Thanks Andrew
>