Sure you can!

Take a look at sp_spaceused in BOL. I would also search the script section here. This will surely return several useful hits.

There is no ROWID() in SQL Server. If you haven't got a *unique* column, I'd say your're pretty much out of luck. However, you can still create an artificial sequential...

Although it seems to be getting better with SP3(a), it is still not completely fixed. My bet is that Microsoft is doing this intentionally to keep user from using EM...

http://www.sommarskog.se/dynamic_sql.html

Read the article and decide if that is the way for you to go

So what?

That won't work. See http://www.sommarskog.se/dynamic_sql.html#cursor how to declare dynamically a cursor.

But more important: Why do you use a cursor anyway?

Search the script library or google. Pretty likely someone else has done this before.

If you expect your database to grow at that speed, I would spent some money on a professional consultant with proven experience in VLDB design. I wouldn't rely on online...

Please don't get me wrong. My reply wasn't meant to be criticism, but rather calling attention on this nasty side-effect of using something undocumented.

Thanks Dinesh!

There is just one thing I like to add.

All of these procedures are undocumented and subject to change anytime at Microsoft's will. I would really carefully think about...

Sorry, for being late on this (was waiting for a friend to explain this to me. You know who you are! )

The reason is...

Look at the explanation of DATENAME. As you are supplying @@datefirst as your date, SQL Server assumes that you are looking for the values of day 7 according to SQL...

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

http://www.winnetmag.com/SQLServer/Article/ArticleID/40505/40505.html

http://www.aspfaqs.com/webtech/062899-1.shtml

http://www.15seconds.com/Issue/010308.htm

http://www.google.de/search?q=sql%2Bserver%2Bpaging&hl=de&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=N

I haven't looked too much into these links, but none of them utilizes a cursor. If you still insist on the use of this thing, do as you pleased.

As I...

Sorry, but I strongly disagree with the answers so far.

As you are obviously after some kind of paging, you have several alternatives, IMHO:

1 (and maybe best): If you only need...

Was bedeutet WiWo?