Viewing 15 posts - 16 through 30 (of 61 total)
Sounds like you have some corruption. Have you run CHECKDB?
March 3, 2006 at 11:18 am
"when I change any data at subscriber". Did you mean publisher?
Your subscriber is missing the update proc for
.
March 3, 2006 at 11:13 am
Both varchar and nvarchar are variable length, meaning they use space according to what's stored.
The difference is nvarchar can store unicode data.
You can read more in Books Online.
March 3, 2006 at 6:57 am
Yes, I believe that's the only way it can pick up the profile.
March 3, 2006 at 6:54 am
There's no built in function to do this.
The self join doesn't use temp tables.
March 3, 2006 at 6:45 am
You're going to have to read the original Excel file into SQL, then export each location to Excel.
March 3, 2006 at 6:43 am
You can do a self join or put your data into a temp table/table variable that has an identity and select from that table.
Self Join...
USE PUBS
GO
SELECT (SELECT COUNT(au_id)
FROM Authors...
March 3, 2006 at 6:30 am
Yeah, sorry I wasn't clear with my first post. There's no need to stop SQL to perform a backup. As Norene points out you want to do this during your...
March 3, 2006 at 6:12 am
Sounds like SQL Server service isn't getting restarted.
It's really better to back up SQL to disk, then back up that file to disk, rather than backing up directly to tape. ...
March 2, 2006 at 1:45 pm
I'll answer here too in case you've abandoned your other post...
Do you really need the data in this format as you indicated this was for a...
February 20, 2006 at 2:07 pm
Try this...
declare @tablename sysname
--set your table name here
set @tablename = ''
create table #tablecols
(
colname sysname,
colid int
)
declare @colname sysname, @sql nvarchar(4000), @rowcnt int, @colid int
insert into #tablecols
select c.[name], c.[colid]
from sysobjects...
February 20, 2006 at 11:50 am
You can't put a result set into an INT. Are you looking for the count?...
DECLARE @RETURNEDROWS INT
SELECT STATUS, SCHOOLNUM, STULINK, [SEQUENCE], USERFIELD1, USERFIELD2,
USERSTAMP, DATESTAMP, [TIMESTAMP],
SCHLYEAR,FROMDATE,TODATE,SCHLATTNUM,SCHLATTNM,
CITY,STATE,GRADELEVEL, COUNTRY, BYAUTOPROC, EOYSTATUS, RESERVED,FILLER,
SCHOOLFLAG, DISTNO,...
February 13, 2006 at 12:47 pm
Viewing 15 posts - 16 through 30 (of 61 total)