If you have a table in a publication you won't be able to rename the table, unless you drop the publication, rename the table, and then recreate the publication. To know if the table is in any publication, execute SELECT article FROM Distribution.dbo.MSArticles WHERE Article = 'yourTable' from the distributor.
2003-05-02
I suppose I should have clarified... I want to do this without using dynamic SQL.
2003-05-02
1 reads
Look at sp_help_job in BOL you can look for a job with a specific @execution_status. This should help.
2003-05-01
Something close to this: char(asc(right(colname,1))+1) Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-01
Run performance monitor to see which processes are consuming the CPUs. Are any other applications except SQL Server running in same box? If you comfirm the high CPU usage is caused by SQL Server, Run Profiler to trace the queries that have high CPU usage and examine the query's execution plan and indexes.
2003-05-01
1 reads
Well, that's where I'm getting my information. The task manager shows sqlservr.exe =99%, but I can't find out /what/ is taking all the cpu.
2003-05-01
1 reads
I would actually connect to the server or go to the console and run Task Manager and see which process is using all the CPU. It sounds like the results from sp_who2 showed no SQL process having high CPU cycles so, it may be something else is hitting the processor. Just my thoughts. David
2003-05-01
1 reads
2003-05-01
1 reads
Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included
2003-05-01
2,698 reads
The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.
2002-06-19
4,470 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers