2001-10-06
3 reads
security
copy data to SQL Server by checking (available)
Hello, I connect from SQL Server on Windows 2000 to Progress Database on UNIX. The database name of SQL Server is cstarsql and the name is cstarint on UNIX. I would like to schedule to copy data from cstarint(Progress) to cstarsql(SQLServer). I did for one time, but I want to control if the data has […]
2001-10-01
3 reads
dbo user with a NULL Login
Have you ever come across this scenario? I know you can have logins without users, but users without logins????! If I create a new database on this particular server the dbo instance in the new database is also NULL. I've checked MODEL and in this and all system databases dbo has a login of SA […]
2001-09-26
96 reads
Permission Problems
I'm hoping someone out there can lend some assistance. I've been beating my head against a wall for a few days and have pretty much given up. Here's the deal... I have a stored procedure that calls the following line of code: execute master..xp_cmdshell 'bcp "select * from intranet..btprintqueue" queryout d:\sqlbackup\printfile.dd -T -c -t,'If I […]
2001-09-25
368 reads
Update: Funny Windows Error
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/funnyerrormessage.asp
2001-09-23
2 reads
Redirecting DTSRun Output to a file
I was reading that with DTS 2000 you can redirect the output from DTS Run to a file. Can you do the same in 7? I was trying and kept getting an error that when had the > file name, it thought it was part of the name of the DTS Package. Here is my […]
2001-09-21
7 reads
Hotfixes + Securing a SQL Server [?]
I was wondering if there are mailing lists or something similar that deal with keeping a sql server DBA up to date with Hotfixes and registry settings that need to be applied to SQL Server. i am signed up to a few SQL lists but would like this infomation as soon as it comes available.
2001-09-21
1 reads
SQL Server Security Best Practices
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
Using Uniqueindentifier Instead of Identity
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/usinguniqueindentifierinsteadofidentity.asp
2001-09-15
6 reads
Backup's via Stored Procedure
I have a stored procedure that is sceduled in a job that will backup the databases and will also perform transaction backups. I want to know how to delete old .BAK files and .TRN files. It should be able to delete the files that are older than 2 weeks. Code with an explaination would be […]
2001-09-10
12 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers